Senior Developer, Lead Resume
Madison, WI
EXPERIENCE SUMMARY:
- Over 15 years of IT experience in Analysis, Design, Modelling, Development, Testing and Implementation of Legacy and Data Warehousing Applications
- Worked primarily in the domain of Insurance, Retail business and Public welfare
- Performed various roles (Delivery Lead, Application Lead, SME, Programmer, Coordinator, Data Analyst & Tester)
- Strong experience in entire life cycle of Data warehouse using Informatica Power Centre
- Thorough knowledge of Ralph Kimball's Data Modelling concepts including Dimensional Modelling, Star and Snowflake schema, Slowly changing Dimensions (Type1, Type2, and Type3), Fact & Dimensions tables, Physical & Logical Data Modeling and Surrogate Keys.
- Experience in relational DB designing, physical/logical designing
- Extensive experience in PL/SQL programming, complex queries, cursors, stored procedures, Functions, Triggers, Views, and Synonyms.
- Exposure in using CASE tools like ERWIN, TOAD, VISIO, SQL Navigator and SQL Developer for database design.
- Good Experience in analysis and resolution of bottlenecks for tuning mappings to improve performance.
- Proficient in design and development of various Dashboards, reports utilizing Tableau Visualizations.
- Extensive experience in generating the reports using Business Objects Designer, Web Intelligence (WEBI) tools
- Having good experience in Agile & Waterfall Methodologies
- Strong design, development and analytical skills
- Possess Excellent Communication, Interpersonal and Leadership skills
- Ability to work on multiple projects at the same time and deliver quality output on time
- Ability to adapt new technologies quickly and work efficiently independently as well as in team
TECHNOLOGY:
Operating Systems: Windows, z/OS
Languages: JCL, COBOL, PL/I, VB
OLTP: CICS
ETL: Informatica 9.X and 10.x
Reporting: SAP Business Objects, Tableau, Power BI
Database: DB2, IMS DB, Oracle, SQL Server
Tools: & Utilities Xpediter, CA7, Telon, QMF, UACR, Control - M, Changeman HP SM, JAMA, JIRA, SharePoint, SAFe, Jenkins, Git, CI/CD Process, Robo Ftp script, Autosys
PROFESSIONAL EXPERIENCE:
Confidential, Madison, WI
Senior Developer, Lead
Environment: - Informatica Power Center 10.x, SAP Business Objects, Oracle 10g, SQL Navigator, SAFe, Jenkins, Git, CI/CD Process, Robo Ftp script, Autosys, SerivceNow
Confidential, Madison, WI
Senior Developer, Lead
Environment: - Informatica Power Center 9.x/10.x, Oracle 10g, SQL Server, CONTROL-M, ToadSAP Business Objects, Tableau, Windows Shell Script, JCL, Cobol, DB2, ChangeMan, CONTROL-D
Confidential, IL
Senior Developer, Lead
Environment: - Informatica Power Center, Oracle, JCL, VS-COBOL II, PL/I, DB2, IMS DB, BTS, Xpeditor, RMS, SMA
Confidential, NJ
Senior Developer, Lead
Environment: - z/OS, JCL, VS-COBOL II, Quickjob, DB2, RPG, UACR, Xpeditor, Endevor, File Aid for DB2, Panvalet
Confidential, CT
Senior Developer
Environment: - z/OS, JCL, VS-COBOL II, CICS, Telon, DB2, RPG, UACR, Xpeditor, Endevor, File Aid for DB2, Telon, Panvalet, UACR
Confidential, IA
Developer
Environment: - IBM 3090 and MVS, VS COBOL II, DB2, JCL, WORKBENCH, IBM Debugger, File Aid for DB2, File Aid, Panvalet
Responsibilities:
- Performed various roles (Delivery Lead, Application Lead, SME, Programmer, Coordinator, Data Analyst & Tester)
- Strong experience in entire life cycle of Data warehouse using Informatica Power Centre
- Thorough knowledge of Ralph Kimball's Data Modelling concepts including Dimensional Modelling, Star and Snowflake schema, Slowly changing Dimensions (Type1, Type2, and Type3), Fact & Dimensions tables, Physical & Logical Data Modeling and Surrogate Keys.
- Experience in relational DB designing, physical/logical designing
- Extensive experience in PL/SQL programming, complex queries, cursors, stored procedures, Functions, Triggers, Views, and Synonyms.
- Exposure in using CASE tools like ERWIN, TOAD, VISIO, SQL Navigator and SQL Developer for database design.
- Good Experience in analysis and resolution of bottlenecks for tuning mappings to improve performance.
- Proficient in design and development of various Dashboards, reports utilizing Tableau Visualizations.