Sql Server Data
Resume:
Siri R
Irving, TX
*********@*****.***
SUMMARY: 8+ years of extensive experience in IT Industry in all phases of the software development life cycle (SDLC), including requirements gathering, development, testing and implementation.
• Over 6 years of experience with ETL methodology for supporting data extraction, transformations and loading in corporate wide ETL solutions using SQL Server Integration Services (SSIS) and Informatica.
• Experience with SQL Server Analysis Services (SSAS) cubes and SQL Server Reporting Services (SSRS) reports.
• Expert in working with different RDBMS including SQL Server, Oracle and DB2.
• Experienced in data warehouse modeling, data warehouse/data mart analysis, design, and implementation.
• Experienced in optimizing, debugging, tuning and testing T-SQL, PL/SQL and SQL queries, views, user defined functions, triggers and stored procedures.
• Interacted effectively with other members of the business engineering, quality assurance, end users and other teams involved with the full System Development Life cycle.
• Worked in on-site and offshore model environment.
EDUCATION: Master in Computer Applications (MCA), SV University, India
CERTIFICATION: Microsoft SQL Server Certifications:
TS: Microsoft SQL Server 2005 – Implementation and Maintenance (MCTS: 70-431)
PRO: Designing Database Solutions using Microsoft SQL Server 2005 (MCTS: 70-441)
TECHNOLOGY:
ETL Tools: Informatica PowerCenter 7.1/8.6, SQL Server Integration Services (SSIS 2005/2008), Ab Initio, DataStage
OLAP Tools: Cognos 8 (Report Studio, Query Studio, Framework Manager, Cognos Connection), SQL Server Reporting Services (SSRS 2005/2008), Business Objects 5.1/2000, OBIEE 10G/11G
RDBMS: Oracle 8.0/10g/11g, MS SQL Server 2005/2008, DB2, DB2/400, Sybase, MS-Access
Domain: Insurance, Manufacturing, Telematics
GUI Tools: Visual basic 6.0
Web Tools: HTML, DHTML, JavaScript, XML, XSLT
Data Modeling: Microsoft Visio, Star-Schema & Snowflake-Schema Modeling
Languages: C#, .net, JAVA, RPG/400, RPGIV, COBOL/400, CL/400, SQL, PL/SQL
Others: MS-Office (Word, Excel, PowerPoint), SYNON/2E, Team Foundation Server (TFS) 2005, Aldon Change Management System, Aqua Data Studio, DAC
Operating Systems: OS/400, UNIX, Linux, Windows XP/7, Windows 2003/2008
CRM: Siebel 8.0, BPCS
EXPERIENCE:
2/12 – Present Pandera Systems
Senior ETL/BI Consultant through Gallop
• Designed and deployed ETL solutions in SSIS. Imported data from OLTP, flat files, or other data sources (Oracle and XML files) and created data flow solutions to cleanse and validate imported data. Inserted and/or updated newly cleansed and validated data into OLTP or OLAP databases.
• Developed and supported SSRS reports.
• Interacted with Business Analysts for requirements gathering, business analysis, and testing.
• Designed mapping document, which is a guideline for ETL coding.
• Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS). Analyzing facts and dimensions for data analysis and design within SSAS. Created KPIs for reporting of scorecards and/or performance management. Created and deployed cubes, perspectives, hierarchies, aggregations, users and roles in SSAS.
• Created stored procedures, functions, common table expressions, and views from T-SQL; queried OLTP data with T-SQL and OLAP (fact and dimension) data with MDX. Applied data warehousing concepts to SSAS solutions.
• Involved in unit and integration testing.
Environment: SSIS 2008, SSRS 2008, SSAS 2008, Oracle 11g, PL/SQL, SQL Server 2008, Toad, Windows Server 2008,.NET,C#
10/11-01/12 Atrium, Dallas TX
Senior ETL/ BI Developer
• Extracted data using SSIS from different regions and other brand companies, and built a data warehouse.
• Maintained old DTS packages and also converted DTS to SSIS packages.
• Developed and supported reports using SSRS.
• Interacted with Business Analysts for requirements gathering, business analysis, and testing.
• Translated business use cases and requirements into data models.
• Designed mapping document, which is a guideline for ETL coding.
• Developed and supported ETL packages using SSIS.
• Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Integrated multiple data sources data like flat files, SQL Server and Oracle databases.
• Involved in unit and integration testing.
Environment: SSIS 2008, SSRS 2008, SSAS 2008, Oracle 11g, PL/SQL, SQL Server 2005/2008, Toad, Windows Server 2003/2008,.NET,C#
05/09-09/11 Agero, Irving TX
Senior ETL/BI Developer
• Extracted data from different source systems including databases, flat files, and XML files, and transformed and loaded them into the data warehouse using Informatica ETL tool, and generated reports using Cognos.
• Developed and supported ETL mappings using Informatica and SQL Server Integration Services (SSIS).
• Changed the mappings/mapplets, and created mappings using Informatica PowerCenter.
• Generated reports and created dashboards.
• Created SSIS packages to place the files in FTP location and to load data into the data warehouse.
• Interacted with Business Analysts for requirements gathering, business analysis and testing.
• Translated business use cases and requirements into data models.
• Parsed high-level design specifications to technical specifications, which required simple ETL coding and mapping standards.
• Designed mapping document, which is a guideline for ETL coding.
• Extensively worked on Siebel Call Center tables.
• Created SSAS cubes and MDX queries.
• Worked on data modeling, star schema modeling, and snow flake modeling fact tables and dimension tables.
• Developed PL/SQL functions, wrote Oracle SQL queries, and created views for reports
• Developed T-SQL and stored procedures.
• Used SQL Profiler to capture slow running queries and stored procedures.
• Integrated multiple data sources data from flat files, XML files, and Oracle, SQL Server and Sybase databases.
• Fixed invalid mappings, and tested stored procedures and functions, Informatica sessions, batches and the target data.
• Involved in unit, integration and performance testing.
• Created Siebel Analytics/OBIEE repository (physical, business and presentation layers).
• Developed and supported reports for existing and new clients in OBIEE 11G, Cognos and SSRS.
• Built dashboards and reports in OBIEE 11g, and optimized performance issues by fine tuning SQL statements.
• Created list, cross tab and drill through reports and dashboards using Cognos Report Studio.
• Used Aqua Studio to connect to different databases including Oracle, SQL Server and Sybase.
• Wrote SQL Queries, Stored Procedures and Views for reports.
• Helped team members with Informatica, SSIS and Cognos.
• Wrote UNIX scripts.
• Configured workflows, tables, execution plans and change capture using DAC.
• Verified and analyzed incoming source data and identified fields and records that needed to be fixed.
• Created and deployed Reports utilizing SSRS. Created parameters for SSRS reports as well as drill-down and interactive sorting capability. Implemented subscriptions and snapshots in the SSRS Report Manager. Integrated reports from SSRS with SharePoint 2010.
• Developed Performance Point services dashboard for proof of concept to show SSAS cubes data.
Environment: SQL Server Integration Services (SSIS) 2005/2008, SQL Server Reporting Services (SSRS) 2005/2008, SQL Server Analysis Services (SSAS) 2005/2008, Informatica PowerCenter 9.0, Oracle 11g, PL/SQL, SQL Server 2005/2008, Unix, Siebel 8.0, DB2, Sybase, Cognos 8.1, OBIEE 11g, MySQL, Aqua Data Studio, DAC, Windows Server 2003/2008, .NET, C#, SharePoint 2010
03/08-12/08 Goodyear
ETL Developer/Consultant through Innosource, Inc
• Moved all the backup data off the mainframe to an Oracle database running on a Windows platform using SQL Server Integration Services (SSIS).
• Used SQL Server Integration Services (SSIS) for all nightly retrieved mainframe data transferred to Oracle.
• Analyzed the mainframe’s source data.
• Designed the target database.
• Identified business rules for data migration.
• Used SQL Server Integration Services (SSIS) to transfer mainframe VSAM file data to Oracle.
• Designed mapping document, which is a guideline to ETL coding.
• Created stored procedures to support efficient data storage and manipulation
• Created SQL Server Integration Services (SSIS) packages to extract, transform and load (ETL) data into the target tables.
Environment: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), mainframe, DB2, COBOL, VSAM, Windows XP, Microsoft Visio, Oracle 10g, SQL Server 2005, VB.NET, Team Foundation Server (TFS) 2005
11/05-02/07 Mindtree
Developer through Mindtree Consulting
• Extracted, transformed and loaded into data marts using SQL Server Integration Services (SSIS), and generated the reports using SQL Server Reporting Services (SSRS).
• Analyzed the source data systems.
• Identified business rules for data migration.
• Wrote technical specifications (simple ETL coding and mapping standards) based on high level design specifications.
• Created SQL Server Integration Services (SSIS) packages to extract, transform and load (ETL) data.
• Created complex drill-down reports using SQL Server Reporting Services (SSRS) 2005.
• Created stored procedures, functions and triggers.
• Rewrote legacy DTS packages to SQL Server Integration Services (SSIS) packages.
Environment: SQL Server Integration Services (SSIS) 2005, SQL Server Reporting Services (SSRS) 2005, SQL Server Analysis Services (SSAS) 2005, SQL Server 2005, Oracle 9i, mainframe, VB.NET, Visual Source Safe (VSS)
10/04-11/05 Satyam Computers
Software Engineer
• Analyzed, designed and developed technical documentation.
• Worked with SSIS packages for ETL.
• Created stored procedures to build business rules to load data.
• Maintained development, test and production SQL Server Integration Services (SSIS) packages.
• Scheduled and monitored SQL Server Integration Services (SSIS) packages.
• Created various reports including list, tab, and drill through reports using SSRS.
Environment: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server, Windows 2003/XP
04/02-10/04 KMG InfoTech
Software Engineer
Ridge Tools
• Provided technical support for the product – BPCS EPR package used to automate the manufacturing process.
• Developed system enhancement reports to meet the client’s day to day business requirements.
• Analyzed the requirements, prepared technical specifications and developed and supported the reports.
Environment: RPG IV, CLLE, DB2/400, BPCS ERP Package, Report Net 1.1(MR1), Cognos Connection, Report Studio, Frame Work Manager, Oracle, DB2, and Windows 2003, RLU, SDA, SEU, PDM, Query/400
Replacement Lens Insurance
• Supported help desk issues, and enhancements to the current system through SIR / SER (System Investigation / System Enhancement Reports) to meet the client’s business requirements.
• Analyzed client requirements and resolved technical problems.
• Sub-file programming, Coding, bug fixing, testing and support the existing application,
Environment: COBOL/400, CL/400, DB2/400, SYNON/2e, SDA, SEU, Query/400
Contact this candidate