Gurwinder Singh

 GURWINDER SINGH -  - Seeking challenging project management assignments to leverage experience and expertise with an organization of repute Highly accomplished and dynamic IT Professional with an extensive & a successful career record in Project Management, Delivery Management, Leadership and Team Management skills offering 12.3 years of experience in Software Application Support and Enhancement; presently working with HCL America Inc. as Project Lead. Hands-on experience in agile and waterfall methodologies Project Management including planning, execution, monitoring, scheduling and estimation of medium to large sized projects involving complex business solutions Adept at analyzing complex business requirements and selecting & customizing emerging technology to meet unique functional specifications Implemented best practices in different projects for smooth delivery as per customer requirements Change agent & problem solver with a passion for technology; skilled at grasping the big picture, conceptualizing, developing, implementing solutions & partnering closely with business leaders & senior level executives Eminent leadership expertise with an exemplary record in driving teams for successful execution of projects Manage cross-functional teams; deep understanding of quality management in a service environment; leadership in designing of creative solutions aimed at maximizing customer satisfaction Demonstrated ability in effectively planning, coordinating & meeting deadlines. Self-driven, able to prioritize tasks and implement changes smoothly High-level leadership and mentoring ability. Excellent interpersonal and communication skills Around 6 years of International experience with Merck & Co. Inc., Blue Bell, Philadelphia, US; Merck & Co. Inc., Rahway, New Jersey, US; Pfizer Inc., Peapack, New Jersey, US; Pfizer Inc., New York, US,Tyco Internation, NJ;Intel Corp NJ; USAA Texas Career Related Skills Project Management Project Planning & Execution Software Application Support & Enhancement Requirement Gathering & Analysis Delivery Management Technology Leadership Business Development Solutions Strategic Planning Client Relationship Management Quality Assurance Client Coordination Team Management Resource Planning SLA Management Escalations Handling Root Cause Analysis Documentation Report Preparation Troubleshooting Ability Technical Support Technical Proficiency Operating Systems:Windows 2000, XP, Unix Languages: PL/SQL, SQL Databases: Oracle 9i & 10g,SAS, DB2 Domain Knowledge: Pharma & Healthcare Tools: SQL Navigator, Toad for Oracle Reporting Tools:- SAP BO, Crystal Reports, Webi, BEx Query, Design Studio,Tableau. ETL :-DataStage, SSIS Scripting :- Shell & Perl Scripting Certifications / Trainings Six Sigma Green Belt Certification Attended SQL, PL/SQL trainings Underwent ITIL training Successfully completed MS Project training Attended seminar on White Paper Presentation Executive Highlights Recipient of Best Employee of Quarter Award for 3 consecutive quarters. Value add Champion Professional Contour ORGANIZATION DESIGNATION DURATION HCL Technologies Ltd., Noida Project Lead Lead Engineer Jun’15 – Present Jun-12 - May-15 Sr.Software Engineer May’09 - May’12 Software Engineer May’06 – May’09 Projects Experience Project#1 USAA :- Enterprise WorkList and ECT Doc Tracking Client USAA Inc. Operating Software Windows XP, Unix Languages SAP BI/BO, ETL Databases DB2, Oracle Tools Squirrel, Control-M, IDT, UDT, Crystal Report,Tableau Role Team Lead Team size 15 Description EWL & ECT teams did not have ways to track and measure MSR performance, policy document tracking, customer satisfaction measure and the trend analysis metrics. Responsibilities Created single and multisource universes using IDT & UDT. Automated existing excel reports into dashboards, Webi or crystal reports,Tabelau dashboards as per the requirements to reduce manual efforts and errors. Designed and distributed Tableau dashboards which reported on various aspects of the business unit. Worked with stakeholders to fine tune these files so that the data helped drive their decisions. Scheduled reports using SAP scheduler and Control-M job Scheduler. Managed reports through the development life cycle in order to get them signed off and moved to production Collaborated with the product manager to ensure a cohesive vision for the product. Participated in project planning sessions to analyze business requirements and outline the proposed solution Performed analysis of potential system changes and presented findings according to the Triage process Translated business requests into actionable requirements for the development team. Collaborated with the development team within the Agile process to ensure a product which exceeds customer expectations in both features and quality. Developed a process for gathering requirements for new reports to standardize the process. Analyzed the security model to ensure proper access levels and prevent access overlaps Migrated universes from UDT to IDT. custom tools used in the administration of the BI environment Completed data load and usability cases Project#2 USAA : Real Estate Reward Recognization Client USAA Inc. Operating Software Windows XP, Unix Languages Base SAS, SAP BI Databases Oracle 12c, SAS Tools SAS EG, Webi, Crystal Reports, Tableau Role Team Lead Team size 12 Description Real estate team launced a new campaign to increase sales, customer base and business value across the US but the team was missing reporting part to understand how the campaign is doing against othe competitors, who could be targeted customers, how many times a particular customer visit the real estate website and shows interest in our product. Also, the senior management was missing the part before and after campaingn live numbers Responsibilities Provided consultation on how to apply technology to identified business scenarios which could range across a number of business process owners Developed a detailed understanding of how processes from different departments interrelate and documented business process flows that are understandable by user departments and are used as a basis for system improvements. Captured the KPIs and Goals, and worked towards creating value by data driven reports and dashboards using SAP BO & Tableau. Worked with Business Intelligence Administrators to manage, upgrade, update BI platforms Worked with Data warehouse, Data Analytics and DBA team to ensure valid and updated data. Captured the real estate Data assets and leverage Business Intelligence tools to create standard reports, dashboards and other components. Captured and converted business requirements into technical solutions. Automated existing reports using Excel Macros(VBA) to reduce manual efforts and errors. Perform data analysis on third party data and compare it with the existing data in SAS and find and suggest the solution for data anomalies using proc SQL. Create real time automated reports based on YoY, MoM, MTD and YTD along with daily flash reports. Worked on Base- SAS and SAS macros as well Project#3 Intel : Gobal Sales out Client Intel Corp. Operating Software Windows XP, Unix Languages PL/SQL, SQL,SAP BOBJ, Databases Oracle 10g Tools SAP BO/BI, Tableau Role Project Manager Team size 20 Description Post the database and application migration, the quarterly sales numbers was dropped significantly for all the GEO’s, data duplication,invalid data and the process of DWH and application connections caused the quarterly revene reports to show a loss in sales figure. The process of data migration was completely missing . Responsibilities Implement agile management ideals by facilitating exercises such as sprint planning and team leading standup for the global team Managed an agile team of contract and third party workers, including: directing flow of work to team based on ability of individual members, planning the movement of processes and responsibilities between teams, interviewing and making hiring decision for team members, and training employees. Set up a process in sales out data reconciliation between Intels systems like CIM (customer information management), HMT (Heirarchy Management Tool),ERPM (Enterprise Registration and Profile Management), NEXT and EDW (Enterprise data warehouse). Reported quarterly results of online sales centers to executive management showing the improvements in sales figure due to the amount of work done by team. Worked on Intels enterprise data warehouse to create data cleansing scripts and routines on business accounts and contacts including automating a solution to track the movement of a business organization's association with customer information management hub's entry Wrote stored procedures to update database from upstream source, conducted extensive data quality checks to ensure data integrity. Developed front end reports for the users to access data using MSBI. Created different report views like trend analysis, sales out, Data Anomaly report for business leads across EMEA, APAC, ANZ and AMER Geo’s. Cleanse end customer sales data submitted by distributors Project#4 EMCA – EXTERNAL MEDICAL COMMUNICATION & AFFAIRS Client Pfizer Inc. Operating Software Windows XP, Unix Languages PL/SQL, SQL Databases Oracle 10g Tools HP Service Center, SQL Navigator, Putty Role Team Lead Team size 8 Description EMCA is responsible for all the support and enhancement of Pfizer medical applications that is used by different medical field personals. They provide support for the following applications: PRIMA, RIOS, FDS, PMI, Eldorado, MIRA et al. Responsibilities Spearheaded a team and ensured that all issues are fixed in time Instrumental in requirement gathering from the Client and use the appropriate resources to complete the task Efficiently prepared different matrix data and reports and submitted to the Senior Management Proficiently handled all the escalations Single point of contact between the Client and the Organization Organized and coordinated all the meetings with external vendor and multiple teams within Pfizer Monitored the data load and sent notifications to the appropriate groups Configured database specific to users and divisions Involved in analyzing and remediating the errors during the data load Responsible for the maintenance and enhancement of different applications Created scripts to close all the business errors Analyzed and rectified root cause of the errors and database issue for FDS Configured the product for PRIMA Generated reports for product usage and document maintenance Configured user preferences for PRIMA users Efficiently performed FDS data load Conducted issue analysis during the FDS data load PRIMA account set up Project#5 DXS – DATA EXCHANGE SERVICES Client Merck Research Lab Operating Software Windows XP Languages PL/SQL Databases Oracle 10g Tools Merckury, Remedy, Windows XP Role Lead Engineer Team size 8 Description DXS is responsible for all external data integrations from outside Lab Vendors and external data providers in support of MRL clinical trials. They provide support for the following products: EDM, All integrations for external data loading to InForm (electronic data capture tool), namely LABS, ECG, EDIARY, IVRS, and PFT data types. Responsibilities Configured database specific to the vendor and integration Efficiently created and uploaded the mock files in UAT Created scripts to close all the business errors Configured the study for EPDS data load and performed EPDS data load Instrumental in configuring the study for EDM data load and performing EDM data load Executed issue analysis during the EDM data load Responsible for EDM account set up Educational Credentials BE (Information Technology) from NRI Institute of Information Science and Technology, Rajiv Gandhi Technical University,India in 2005 with 73% Personal Particulars Date of Birth: 22nd July, 1982 Languages Known:English, Hindi & Punjabi Location Preference:none Passport Number:G- Visa Status:H1B Valid Visa