Qualification/Exprience

• Bachelor of Engineering In Computer Science and Technology.
• Over 5 years of experience in implementing SSIS 2008 packages and implementing database solutions using SQL Server 2005.
• Experience in entire SDLC cycle of SSIS package development, from blueprinting to development, testing, implementation and post-implementation support.
• Developing SQL scripts (stored procedures, triggers, database scripts) to implement business logic and assist in database maintenance.
• Excellent communication and interpersonal skills.
• Good team player.

• Over 5 years of experience in implementing SSIS 2008 packages and implementing database solutions using SQL Server 2005.
• Project lead on more than 20 SSIS packages development.
• Support Lead for 40 SSIS packages managing a team of 4 resources.
• Experience in entire SDLC cycle of SSIS package development, from blueprinting to development, testing, implementation and post-implementation support.
• Developing SQL scripts (stored procedures, triggers, database scripts) to implement business logic and assist in database maintenance
• Work experience in US, UK and India.
• Good Functional knowledge of retail domain and NRF – PRBC (Retail Domain) certified.
• Experience in creating detail design documents (HLD & LLD) and technical specifications.
• Good problem solving skills and interpersonal skills.
• Ability to work independently and efficiently, managing timelines and expectations.
• Excellent team player with good analytical, trouble shooting, and communication skills.

Operating Systems Windows 7, 2000, NT.XP Professional
Databases SQL Server 2005, Oracle 10g. Teradata 7.0
ETL Tools SQL Server Integration Services SSIS 2008
Reporting Tools Business Objects XI
Database/Modeling tool Teradata SQL Assistant, SQL Server Management Studio, SQL Oracle Developer
Languages T-SQL, C, C++
Other Tools Control-M, ActiveBatch, Remedy, PVCS, Subversion, ClearQuest

• National Retail Federation, US Professional Retail Business Credential in December 2009.
• Cleared ITIL certification through iLearn Module of HCL Technologies Ltd in Jan 09.

06/11 – Till Date Confidential,
US- BI Developer
Project: Business Change Management
Project Description:
I am currently working for Micron Technologies Inc. based in Boise, Idaho.
I am part of their BCM (Business Change Management) team which caters to all the business changes pertaining to BI.
Responsibilities:

• Assigned with individual case/task based on priority, criticality and skills set.
• Involved in requirement gathering, design and development for extracting data from the source systems.
• Worked with analysts and data source systems experts to map requirements to ETL code and conducted analysis with the SME’s.
• Provided an estimated effort and completion date after analyzing the case.
• Conducted Unit testing followed by the UAT before moving any code to Production.
• Worked with DBA’s and system support personnel in elevating and automating successful code to production.
• Have successfully created generic packages that run independently at different sites/locations driven by date/time.
• Created views and granted access to different roles in different schemas.
• Developed complex mappings to load data from multiple source systems like Oracle, SQL SERVER, SAP and flat files to datamart in Oracle database.
• Developed complex mapping logic using various transformations like Lookups, Join, Sort function, Aggregate function, Data Conversion and Derived Column.
• Completed all the cases/tasks within given timeframe.

Environment: SSIS 2008, SQL Server 2005, Oracle 10g, Oracle SQL Developer, Windows 7.

06/07 – 12/010 Confidential,
India – engagement DSGi UK

Project: SSIS Packages
Project Description:
I worked for DSGi plc which is a UK based leading electronic Retail Chain.
As per the business requirement data was integrated from all the system including Oracle, Mainframe, Third party’s CSV files into a single point and incorporated new customer’s fields, new business rules and some complex transformations.
Responsibilities:

• Business requirement gathering and blueprinting at client site in UK.
• Installation of SSIS, establishing connections with remote systems such as Teradata, Mainframes & Oracle.
• Discussing, documenting and validating best practices for SSIS development along with key business team at on-site.
• Development of more than 20 SSIS packages with detailed logging and configuration files for large volume data warehouse.
• Automating the execution of SSIS packages by writing a common script and running the same using scheduler Control-M.
• Maintenance and support of more than 40 SSIS packages.
• Detailed documentation of all packages to assist other team members in efficiently supporting the applications.
• Created and lead a team of three people by imparting SSIS knowledge.
• Contribute in project and task estimations.
• Providing estimates for the YOY growth of the data in the Data warehouse and incorporating housekeeping jobs to manage it.
• ETL tool used to design and develop mapping for extracting, cleansing, transforming, integrating and loading data into different target.
• Worked with DBA’s and system support personnel in elevating and automating successful code to production.
• Provide on call support to production system to resolve any issues.
• Participate in tasks estimation, operating expense to meet deliveries.
• Reviews code and technical designs of other ETL developers.

Environment: SSIS 2008, SQL Server 2005, Oracle, Teradata

ETL Programmer
Project: Supplier Delivery Conformance Application
Project Description:
Supplier Delivery Conformance is a data warehouse application used by DSGi plc for recording the deliveries made by the supplier. The suppliers were charged based on their non-conformances. ETL was used to provide data to the business and then generate reports based on it.
Responsibilities:

• Business requirement gathering for the new enhancements in the projects along with their estimations.
• Communicate with the client during requirements, implementation and acceptance phase.
• High Level Design (HLD) for ETL based on Business requirements.
• Creating Weekly report and discussion with the on-site team and the manager.
• Development of few SQL Server Integration services 2008 packages in the application for the reporting purpose.
• Detailed documentation of all packages/enhancements to assist other team members in efficiently supporting the applications.
• Knowledge of the version control tools such as VSS and PVCS required for maintaining the version of the source code.
• ETL tool used to design and develop mapping for extracting, cleansing, transforming, integrating and loading data into different target.
• Developed logic in Mappings, used fuzzy logic, lookup and other complex transformations.
• Performance SSIS tuning & best practices, reusability, variables, workflow design.

Environment: SSIS 2008, SQL Server 2005

ETL Programmer

Project Description:
Supplier Value Improvement application is used by the DSGi buyers to help them chose the Supplier in an efficient way based on several parameters such as product profitability and performance. The application helped them compare the different suppliers and vendors at a different hierarchy levels starting from Merchandise to the Product(SKU) level.
Responsibilities:

• Writing SQL queries, procedures and resolving Incidents/issues by analyzing the SQL code.
• Monitoring the daily data feeds using a unix based tool: Control-M.
• Working on the new enhancements in the projects.
• Resolving all the issues within the well-defined SLA’s.
• Made several Value Adds in the project including the Splitting up of a data feed to ensure the availability of the application in the business hours.
• Worked as a PQA (Project Quality Analyst) and CC (Configuration Controller) for the Project to ensure the quality standards are maintained.
• Done RCA (Root Cause Analysis) for several problems/issues during Production support.
• Adapting, implementing and ensuring smooth functioning of systems / software with a view to ensure maximum efficiency in warehouse and supplier value improvement application.
• Mapping business requirements and translating these requirements into functional specifications and detailed test plans.
• Creation of service installation plans, procedures and scripts, creation of service release deployment and validation plans

Environment: SSIS 2008, SQL Server 2005

06/06 – 06/07 Confidential,
India
Team Leader
Project: Lisa Home Solutions
Project Description:
Lisa Home Solutions is a real estate company in Pune. The project was to develop the company’s database and centralize it.
Responsibilities:

• Participated in analyzing user requirements.
• Assisted in designing and modifying the existing database to incorporate new requirements.
• Performed database tasks like creation of tables, indexes, views, Stored procedures.
• Developed the Test plan, test case and test scenario.
• Work closely with business analysts, application teams, data modeler, database administrators and reporting teams to ensure the ETL solution meets business requirements.
• Worked with T-SQL, Stored Procedures and Functions to validate the data loaded in the database tables.
• Development and scheduling of jobs.

Environment: Windows XP, SQL Server 2005, Business Objects XI

B.E (Computer Science Engineering) with Distinction