Software Engineer Resume

SUMMARY:

11 years of experience in business intelligence, data warehouse design, data lake, Confidential and data mart design, dimensional data modelling, relational database design, system integration, data architecture and governance.
Proficient in SQL Server 2008 R2/2012 (T - SQL, SSIS, SSRS), Oracle PL/SQL, Performance Tuning , Tableau reporting , Data modeling using ER Studio.
Designed real time / batch based data warehouse and Confidential data ingestion using big data technologies (Hadoop Ecosystem, Hive, Impala, Yarn, Spark, Kafka, Sqoop, Oozie), NoSQL database (MongoDB), other relational databases (Sybase, Teradata), Informatica Power center, Abinitio, Power BI, .Net technologies, XML, UNIX, Autosys, Tivoli workload scheduler, Connect Direct (DTU).
Proficient in data analysis and created data warehouse design documents (Including Datalake), ETL Mapping Specifications, data flow diagrams, presented solutions to stakeholders and technical audiences.
Worked in Agile-Scrum, Waterfall and Support methodologies.
Involved in Disaster recovery (DR) environments setup for applications, Replication setup, performed data warehouse/ Data marts sizing estimation, data warehouse environment setup.
Has experience of Wealth, Investment and Corporate banking, Healthcare and Retail data warehouse projects.
Excellent written, verbal and communication skills. Ability to solve complex technical/business problems and present the solutions to technical and business level audiences. Effective interpersonal skills to co-ordinate and participate in Confidential team environment and achieve organizational goals .
Completed bachelors of engineering in information technology from Government College of engineering, Aurangabad.

PROFESSIONAL EXPERIENCE:

Confidential

Software Engineer

Confidential

Assistant Vice President

Confidential

Senior Software Engineer

Confidential

IT Analyst

Confidential

Associate Consultant

Confidential

Solution Designer, Technical Lead

Responsibilities:

Requirements gathering/analysis, Data warehouse design, Data marts Design, Creation of mapping specification, Systems integration, Creating ETL mapping specs, Data marts sizing estimation, DR implementation and replication.
Design of real time/ batch data warehouse and Confidential data ingestion using Big Data technologies (Hadoop Ecosystem, Hive, Impala, Yarn, Spark, Kafka, Sqoop, Oozie), NoSQL database (MongoDB), Kudu DB.
Data profiling and validation for generating financial regulatory reports using Abinitio.
Designed and generated reports using tableau for wealth business analysis.
Developed ETL processes for loading data into MongoDB using SSIS
Replaced Informatica with SSIS/SQL Load Processes
Designed and developed data reconciliation processes for data warehouse using SQL stored procedures.
Developed ETL processes for data warehouse load, delivering reports for AML systems, compliance systems, Document processing.
Setup environment for large file transfers using Connect Direct (DTU)
XSD Schema designing for processing XML files received from various systems (XMLSpy)
Optimization of Data Warehouse and Data mart load processes using SQL Server.
Configured and Deployed jobs using Autosys and Tivoli workload scheduler.
Designed custom error handling and logging framework for data warehouse.
Involved in the User Acceptance Testing, system integration testing, Bug Fixing and production support.

Confidential

Senior Developer/ Architect

Responsibilities:

Created data flow diagrams for existing processes and proposed process improvements
Designed and developed SSIS packages for Data Integration, Data Cleansing and Data Validation, Optimized ETL load processes.
Designed and developed SSRS reports for management decision making/ Application users.

Confidential

Developer /Team Lead/ DWH Architect

Responsibilities:

Developed SSIS ETL framework data warehouse load, SSRS reports and designed SSAS Cubes for reporting purpose.
Optimization of DWH load processes.
Scheduling email/data driven subscriptions of SSRS reports
Configured and Deployed JOBs (T-SQL), SSIS packages
Designed custom error handling and logging framework for data warehouse.
Involved in the User Acceptance Testing, Bug Fixing and warranty support.

Confidential

Developer

Responsibilities:

Worked as system designer/integration coordinator, also prepared design documents. (Designed table structures, Data flow, Views)
Played lead role in requirements gathering/analysis, designing and developing system database objects (SPs, Functions, Triggers, Cursors)
Configured and implemented JOBs for all batch processes events such as pushing data to finance DB.(Created SSIS Packages, SSRS Reports)
Presented systems demo to client and prepared user manuals.
Involved in the User Acceptance Testing, production deployments and production upgrade.
Also worked as client SPC for support.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship