Description
SUMMARY OF QUALIFICATIONS * 10 years of experience in Database Design, Development, Testing and Production Environments as a SrBI Developerand Data Analyst. * Good experience in development of SSIS, SSRS, Business Objects, Stored Procedures, Triggers, Functions, Views, T-SQL scripts, SQL, PL/SQL, SQL Server for business logic implementation. * Good experience with data warehouse modelling of ER, 3NF, and Dimensional Star& Snow Flake Schema models for BI reportingand created Fact and Dimension tables for the Data Warehouse using Erwin. * Developed C#.Net, VB.Net scripts as part of ETL (SSIS) Coding * Created SSRS Reports like Parameterized Reports, Linked reports, Snapshot reports, adhoc reports, Clickthrough reports, Drilldown reports, Drillthrough reports, Subreports and KPI Dash boards * Highly experienced in complete cycle of SQL Server Integration Services (2005/2008/2012), Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers. * Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as Requirement Gathering, Development, Testing, Migration, Security management, Training and Support. * Experienced in migration projects like SSIS packages from 2008 to 2012 * Good Logical, analytical, interpersonal skills and commitment to perform quality work as well as excellent team member. * Development in MSBI (SSIS and SSRS), SAP Business Objects and Data Warehousing applications for Retail, Recycling and insurance industries. * Excellent knowledge in creating Databases, Tables, Stored Procedure, SQL Joins, Sub Queries DDL/DML Operations, Views, Cursors and Indexes using T-SQL. * Good experience in Performance Tuning, Logging, Error Handling by using event handlers and custom logging, Check Points, Jobs scheduling and monitoring in SSIS packages * Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements. * Knowledge in creating complex drill down reports, parameterized reports, dropdowns and images, charts using SSRS 2005 / 2008 and SAP Business Objects XI 3.1, XIR2/6 5/6.1/5.1, BO 4.1/4.2. * Proficient in design, development, deployment of SAP Business Objects Universes using Designer (UDT & IDT) and Code migration using PMT in BO 4.1/4.2. * Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into designing database, documenting and rolling out the deliverables. * Participate in the business team meetings to represent the offshore development team to help the business team with technical feasibility. * Responsible for Production, customer issues resolution.
Accomplishments
Highlights:
Keywords
