Data Analysis, Sql/ssis/ssrs Developer Resume
VA
SUMMARY:
- Over 8 years of professional experience in System Analysis, OLTP System Design and development, ETL Design & Development, BI/DW, Data Migration, Client interfacing and Technical issue resolution.
- Experienced in programming tasks - Stored Procedures, Triggers and CursorsusingSQL Server 2012/2014withT-SQL.
- Involved in Huge data migrations, transfers using utilities likeData Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
- ExcellentT-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions.
- Design and develop SSIS packages, store procedures, configuration files, tables, and views; implement best practices to maintain optimal performance.
- Build efficient SSIS packages for processing fact and dimension tables with complex transforms
- Proficient in implementing all transformations available on the SSIS toolbox.
- Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
- Developed various operational drill-through and drill-down reports using SSRS.
- Developed different kind of reports such a sub reports, charts, matrix reports, linked reports.
- Used cascaded parameters to generate a report from two different data sets.
- Technical Documentation for DW application
- Undergone Performance Tuning Working with Remote Team
- Agile and Waterfall SDLC Process.
- Global Software Development involving Onsite - Offshore co-ordination.
- Planned, directed and managed data warehouse projects and OLTP systems.
- Executed, simultaneously, multiple projects to success through careful planning, optimal resourcing, iterative development, effective scope management and ensuring timely delivery within budget.
- Great expertise in managing communications within the team and to stake holders to supplement team productivity and manage expectations.
- Backed by strong technical skills, steered team to successfully resolve technical challenges.
- Experienced in Creating Parameterized, Drill Down, Drill through and other complex Reports.
- Experienced in working on performance improvement of reports using caching and Snapshots
- Ability to identify skill gaps based on current and anticipated needs has helped me organize training in different technical area for the team members and prepare the team for immediate needs.
- Estimation and tracking
TECHNICAL SKILLS
BI Tools: MSBI (Sequel Server Integration Services/Sequel Server Reporting Services), PowerCenter, SDT(System Data Tools)
RDBMS: SQL Server 2005/2008/2012, PostgreSQL, IBM DB2, Oracle and MS-Access
Data Warehousing - Core Skillset: MS BI
Web Tools: ASP.NET, ASP, HTML, VBScript, JavaScript and XML
Report Writer: SSRS, Business Objects XI and Crystal Reports
Databases - Core Skillset: SQL Server 2012, SQL Server 2008 R2
Programming Languages: C#, Microsoft Visual Basic, VB.NET
PROFESSIONAL EXPERIENCE
Confidential, VA
Data Analysis, SQL/SSIS/SSRS Developer
Responsibilities:
- Configured load balancing environment for scheduler and ETL tool.
- Troubleshoot existing data load and presentation, perform necessary repairs and improve performance.
- Perform analysis with key stakeholders to develop requirements for new functionality.
- Participate in management level meetings to determine feasibility and perform prioritization of development initiatives.
- Developed complex SQL, PL/SQL, and batch scripts as part of ETL
- Worked closely with internal customers, such as actuarial & management team, to identify information needs.
- Performed performance tuning, increase data functionality, data integrity, and data quality.
- Perform all Development DBA tasks (designing and creating tables, indexes, stored procedures, views, performance tuning)
- End to end development of business intelligence solutions. Solution selection, business analysis, project management, and ETL coding responsibilities.
- Requirements gathering by interacting with Business and writing the Functional specification document
- Created mapping document to build dimension table for Advantage policies, Built the table and updated the keys in required fact tables
- Made code changes in store procedures for Report enhancements.
- Worked with various Control Flows Tasks such as Send Mail Task, Bulk Insert Task, Execute SQL Task and also worked on various Data Flow Tasks
- Maintained look up tables in National Reporting database to ensure data understanding
- Developed Capped tier values for the advantage policies based on business user requirements which is very useful for scoring.
- Using Normalization techniques, eased process of data load, transformation and data extraction.
- Created different objects, many data sets, many reports, stored Procedures, triggers script to populate data into different tables according to different parameters specified.
- Wrote store procedures to feed different applications from SQL Server.Business Domain: Property and Casualty Insurance
Environment: SQL Server 2012, MS-BI (SSIS/SSRS), VSS and JIRA,SQL Server Reporting Services 2012, Oracle, Erwin, C#,ASP.NET Windows XP / NT / 2000/2003/2007, MS Office 2007.
Confidential, TX
Data Analysis, ETL Architect, ETL Developer
Responsibilities:
- Create functional and technical specifications.
- Multi-Dimensional Data Modeling techniques like Star Schema Modeling, Snow-flake Dimension modeling using Kimball Design Methodology.
- Define Conceptual Data model and derive Logical and Physical data model.
- Developed the ETL Staging area and DataMart for the Marketing Data Analysis
- Reverse Engineer and Forward Engineer ERwin Data Models to SQL Server.
- Creation of transformation rules based on analysis.
- Implementation and maintenance of computer based information systems.
- Oversee Day-to-Day operations of the information systems including all computer hardware, software and equipment for a 100+ user environment
- Travel on-site to perform all necessary network configuration and operation supervision
- Evaluate and implement IS procedures and equipment for maximum efficiency and cost containment
- Monitored database performance through SQL Server Enterprise Manager.
- Backup and restore for testing development environment.
- Created all database objects like Tables, constraints, triggers, stored procedures, views, User defined data types for business functionality's and performance, concurrency control, error handling and normalization as major considerations.
- Set up dynamically configured networks and sub-networks of business requirements
- Developing data mapping and data requirements documents.Tuned SQL query for better performance.
- Worked on exporting graphical reports to Excel.
- For version control and sharing file utilized MS Visual Source-safe.
- Implemented query optimization techniques to improve the SQL Performance.
- Data modeling (E-R modeling and physical Data modeling) for the Data warehouse using ERwin and Data warehousing and Data Mart Techniques.Business Domain:Health Insurance
Environment: SQL Server 2005, MS-BI (SSIS/SSRS), VSS and JIRA,SQL Server Reporting Services 2005/2008, Oracle, Erwin, C#,ASP.NET Windows XP / NT / 2000/2003, MS Office 2003/2007.
Confidential, CA
Team member
Responsibilities:
- Developing SSIS package based on Business Rules.
- Implemented SQL SERVER and XML SSIS configuration.
- Migrating the packages from DTS to SSIS
- Migrating the packages from SSIS 2005 to SSIS 2008
- Writing Complex Stored procedures
- Design and developed various types of SSRS Reports
- Involved in SSIS Package maintenance and Scheduling through SQL SERVER AGENT
- Implemented QA database comparison code using SSIS.
- Developed automation tools to improve project productivity. Developed a tool in SSIS and compared two Dimensional database tables or view based on their given column combination and find the duplicate entry in that view or table, also found Null value for the given table and generated an report.
- Developed a tool in SSIS and automated the documentation work as per business rule
- Worked on Partition Logic for the Detail and Event Segment. This Logic enhanced the performance by decreasing the time taken for processing the data.
- Created Batch code which will find unused tables in the database
- Created Batch code which will delete file in a given path based on its created age
- Created Batch code which will replace the DB string with a user define DB name based on position value given on a text file.
- Preparing Dashboard reports based on the performance of servers.
- Provided Training in SSIS, SSRS for entry Level engineers.Business Domain: Windows- Server 2008 R2
Environment:Windows- Server 2008 R2, SQL Server 2008 R2, SQL Server 2012, VS 2012.Windows 2003,C#,VSS 2005,XML,MS Access, MS Sharepoint,ASP.NET, MS Office Access 2003, VBScript, ER-Win
Confidential, Allentown, PA
DW/ Data Architect, Data Mart Developer, Project Delivery
Responsibilities:
- Analyze the requirement and design the high-level user interface and database.
- Designed the applications in the data model using normalization process up to 3NF.
- Identified redundant programming functionality and developed reusable ActiveX controls
- Worked on exporting graphical reports to Excel.
- For version control and sharing file utilized MS Visual Source-safe.
- Implemented query optimization techniques to improve the SQL Performance.
- Development of Stored Procedures as per the given Business Rules
- Written complex Stored Procedures
- Creating and managing schema objects such as tables, views, joins, clusters, indexes, functions, procedures, triggers & maintaining Referential Integrity.
- Used Joins and sub-queries for complex queries involving multiple tables from different databases.
- Optimized the database by creating various clustered, non-clustered indexes and indexed views.
- Involved in SSIS Package, DTS Import/Export for transferring data.
- Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
- Involved in performance tuning of complex Stored Procedures
- Batch File Creation, Macro Creation
- Created standard Reports and Cross Tab Reports and Drill Through reports in SSRS.
- Generated Reports using Global Variables, Expressions and Functions for the SSRS reports.
- Provided Documentation support on SSRS 2005 as assigned and deployed in SharePoint Environment.
- Responsible for scheduling the subscription reports with the subscription report wizard.
- DTS used for import and export functionalityBusiness Domain: Manufacturing
Environment: SSIS, SSRS, SQL Server 2005, ERwin, ASP.NET 2.0, C#.NET and VSS,oracle, MS SharePoint, MS Access 2000 & Windows 2003/2000 platform.
Confidential, NH
Technical Analyst
Responsibilities:
- Created manual and automated test cases for testing the SSRS Reports
- Contributed to the performance improvement of SSRS Reports by fine tuning the SQL Queries.
- Sole contributor from offshore.
- Received engagement feedback of 7/7.
- Analyze the requirement and design the high-level user interface and database.
- Designed the applications in the data model using normalization process up to 3NF.
- Identified redundant programming functionality and developed reusable ActiveX controlsUnderstood Customer requirement via interaction and writing functional specification
- Created different objects, many data sets, many reports, stored Procedures, triggers script to populate data into different tables according to different parameters specified.
- Analyzed the Data quality, Data validating, Data mapping to migrate data to SQL server to over 60 tables.
- Wrote store procedures to feed different applications from SQL Server.
- Transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
- Developed various stored procedures used in the application using T-SQL
Environment:SSRS, VMware, Remote Desktop Connection, Terminal Services, Windows 2000 Advanced Server, Windows 2003 Server, Windows XP, FTP, HP Remedy, SQL Management Studio 2005.