We provide IT Staff Augmentation Services!

Business Data Analyst/sql/ssis Developer Resume

MO

SUMMARY

  • A Lead Business Data Analyst/ SQL/ SSIS Developer with over 8 years of experience with an understanding of Business Process Flows, Case Tools, and Business Analysis.
  • Dynamically handled roles Business Systems Analyst at different assignments.
  • Seasoned professional, with outstanding project execution, monitoring, and coordinating skills with ability to support multiple simultaneous projects in a matrix organizational structure.
  • Experienced in gathering user requirements, analyzing and preparing Project Deliverables such as GAP analysis (AS - IS & TO-BE scenario), Project Charter, Business Requirement Document (BRD) and Functional Requirement Document (FRD) and proposed changes for process improvement.
  • Skilled in Analysis and Design with experience in creating Use Cases, Class Diagrams, Activity Diagrams, State Diagrams, Sequence Diagrams, Unified Modeling Language (UML) using MS Visio and Rational Rose.
  • Demonstrated ability to work actively in different phases of Software Development Life Cycle (SDLC) using Rational Unified Process (RUP) and Agile methodologies (SCRUM) in multi-tier web-based architecture.
  • Used SQL queries to extract data from different databases including testing and production for data validation and data analysis.
  • Highly proficient in working with users and stakeholders to elicit, analyze, communicate and validate requirements and conducting JAD and JAR sessions, identify Functional, Non-Functional, and Business Rules, and then subsequently model them.
  • Conducting User Acceptance Testing (UAT) and verifying performance, reliability and fault tolerance issues. Also familiar with testing tools to design and develop test plans and test cases.
  • Strong understanding of technologies including CRM, ERP, Database & Programming Languages
  • Experienced in coordinating, negotiating and motivating project participants in support of time line and project deliverables.
  • An outstanding communicator with exceptional conflict handling skills.
  • Manage projects from planning through execution/completion under the pressure of fast-paced, time-sensitive environments.
  • Thorough knowledge of Business and Technical documentation - Project charter, Product Definition Document (PDD), Business Requirements Documentation (BRD) and System Requirement Specification (SRS), Test Plans, Test Cases.
  • Extensive experience in MS SQL Server 2008/2005/2000 , Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
  • Worked on SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
  • Involved in writing and tuning Transact-SQL Queries.
  • Experience in upgrading from MS SQL Server 2005 to MS SQL Server 2008.
  • Knowledge of working with BCP, DTS, SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle/ Sybase databases.
  • Experience in creating SSIS packages. Ability in DTS Migration and Metadata Management Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
  • Knowledge in creating the MDX cubes and dimensions.
  • Good knowledge of defining and deploying and developing Star Schema, Snow flake Schema and Dimensional Data modeling, cubes using MS SQL Server Analysis Services (SSAS) on a Data Warehouse.
  • Performed Technical Documentation for functional and business requirements.
  • Worked with MOLAP Cubes by partitioning them, Designing Aggregations, implementing Hierarchies and Calculated Members.

TECHNICAL SKILLS

Databases: MS SQL Server 2008/2005/2000 /7.0, ORACLE, MS Access, teradata V2R6/V2R5, DB2

Database Tools: MS SQL Server 2008/2005/2000 , DB2, MS-Access, SQL Server Integration Services, Data Transformation Services, SQL Server Analysis Services, OLAP(Online Analytical Processing, Multi-dimensional Cubes and Business Intelligence & Development Studio

Development skills: T-SQL, PL/SQL,SSIS/SSRS/SSAS, Pro-clarity

Languages: VB.net, VB Script, T-SQL, SSAS, OLAP, HTML, XML, Java Script, C, C++ and MDX.

ETL Tools: DTS, SSIS (SQL Server Integration Services), Informatica.

Reporting Packages: SQL Server Reporting Services, Business Objects 6.5/XI, Crystal reports 9/10/11, MS Excel.

Tools: /Methodologies: MS Visio, Erwin, MS Project, SQL Profiler, SQL*Loader

PROFESSIONAL EXPERIENCE

Confidential, MO

Business Data Analyst/SQL/SSIS Developer

Responsibilities:

  • Utilized a variety of reporting tools such as SQL, DB2 and MS ACCESS for querying underlying database tables and resolve data issues.
  • Involved in brining 2000 SQL database environment to SQL 2008 by migrating, converting and re-writing DTS packages and updating them to SSIS packages.
  • Identified the sources and target databases and mapped as per the requirement.
  • Working knowledge of database design, optimization and analysis, as well as Microsoft SQL Server 2008, 2012.
  • Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, flat files to SQL server 2008 using SSIS.
  • Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Worked with various SSIS packages which involve Transactions, Restart ability and roll back techniques.
  • Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
  • Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
  • Worked on Data warehousing concepts by gathering the requirements and creating a data model, demonstrated the prototype for new modules.
  • Documented the entire migration for future references.
  • UsedSQL CompareandSQL Data Comparefor pushing changes from test servers to production servers
  • Worked on warehouse for extracting data and send the files to vendor as per requirement.
  • Worked with data modelers and DBA to modify the table structures and dim tables.
  • Build the transformation with business rules and added default values.
  • Performed Unit testing and QA testing one the ETL job results.
  • Understood and built the ETL environment with the specific toolsets.
  • Document the transformations and submit to data governance for approval.
  • Created and translated the high level technical requirements into DI/ETL design in power point and units of work for the DI development team.

Environment: CDMA tool, MS SQL Server 2000/2005/2008 , SSIS, excel, Sybase, PowerPoint, IBM DB2, UNIX, WinSCP, SharePoint T-SQL, HTML, XML, Windows XP.

Confidential, Atlanta, GA

Business Data Analyst/SQL/ SSIS Developer

Responsibilities:

  • Utilized a variety of reporting tools such as SQL and MS ACCESS for querying underlying database tables and resolve data issues.
  • Analysis of the business system design, studied detail changes that need to be made to each business process, modified existing columns of new tables and prepared detailT-SQL scripts.
  • Involved in brining 2000 SQL database environment to SQL 2008 by migrating, converting and re-writing DTS packages and updating them to SSIS packages.
  • Working knowledge of database design, optimization and analysis, as well as Microsoft SQL Server 2008, 2012.
  • Created Many Functional requirement document and got many client appreciations.
  • Designed and developed Business Use Cases.
  • Have good understanding on the client benefit manager and Adjudication system.
  • Mentoring new team members by conducting Knowledge storm session.
  • Created mapping/crosswalk documents for mapping data flow between systems.
  • Conducted requirement walkthroughs with business owners, and requirements review sessions.
  • Conducted JAD sessions for requirements gathering and to cover the Gaps.
  • Developed high level and detail level Business requirements and pass them over to designated factories for technical Analysis and design.
  • Created test cases scenarios for the Functional requirement and making sure QA has understand the changes
  • Work load tracker for the team was maintained and making sure everyone in the team updating it every week before sending to client for status reporting.
  • Acted as a Facilitator in the command center during the Implementation and making sure all the issues are fixed by coordinating with the IT and business folks.
  • Analyzes data by defining quality requirements, making recommendations for changes on the source system, working with users to correct historical data and by applying standard data cleansing in integration services flows using SQL Server 2012.
  • Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries
  • Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
  • Involved in Extract Transfer Load (ETL) processes in integration services packages according to the current business standards.
  • Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server
  • Extensively worked on Data Flow transformations like Foreach Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
  • Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Sort, Pivot and Unpivot Control Flow Transformations.
  • Extensively designed the packages and data mapping usingControl flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task andScript Taskin SSIS Designer.
  • Used SQL Server Package Configuration technique to make Dynamic configurations.
  • Used Text Files/ SQL Server Logging for all SSIS packages.
  • Developedlogical packagesto update the new table’s column.
  • Involved in resolving all issues fromtesting issue log sheet.
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using Report Definition Language (RDL).
  • Created Drill reports which give all the details of various transactions like closed transactions, summary of transactions and scheduled this report to run on quarterly basis.
  • Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.
  • Created complex correlated sub queries to generate reports.
  • Deployed and configured the reports in the Report Server.
  • Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, flat files to SQL server 2008 using SSIS.
  • Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Worked with various SSIS packages which involve Transactions, Restart ability and roll back techniques.
  • Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
  • Involved in setup and configuration of CDC to extract rows that have been inserted, updated, or deleted via T-SQL queries.
  • Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
  • Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
  • Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
  • Schedule the packages to keep extracting the data from OLTP at specific time intervals.
  • Responsible for rebuilding the indexes and tables as part of performance tuning.
  • Monitored performance and optimize SQL queries for maximum efficiency.
  • Scheduled SSIS packagesfor running monthly and weekly feeds from various departments and multiple servers and resources to Development Servers.
  • Optimized queries using SQL Profiler and Database engine tuning advisor.
  • Configuration and Deployment of all reports across various SDLC environments.
  • Developedtesting data warehouse table scriptto load data from temp table to new table and drop the temp table.

Environment: MS Access, Windows XP SQL Server 2012, 2008 R2/ 2008/2005/2000 , SSIS 2008, SSRS, C#, ASP.NET, DB2, Oracle 9i/10g, Visual Studio 2005, XML, XSLT, MS Office and Visual source safe.

Confidential, Newbury Park, CA

Business Data Analyst/SQL/ SSIS Developer

Responsibilities:

  • Involved in various business analysis meeting and created the business requirement document according to end client’s needs.
  • Comparing the Source system with the EDWARD Data and identifying the discrepancy
  • Creation of UAT Test Plan Scenario document and Test result document
  • Worked with SQL queries for data manipulations, Data extraction and Data Mapping
  • Interaction with Business folks and helped them in Issue Resolution.
  • Identifying the Issues and escalating it at the Wright time (UAT).
  • Get necessary Business and IT Approvals
  • Responsible for performance tuning of existing SSIS packages and introduced dynamic configurations, custom logging, Error Handling etc.
  • Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
  • Created the workflow documents for all existing and new SSIS packages.
  • Responsible for Troubleshooting Report Processing, Subscription, Delivery and Configuration
  • Developed Query for generating drill down and drill through reports in SSRS.
  • Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
  • Identified and worked with Parameters for parameterized reports in SSRS 2008.
  • Responsible for scheduling the subscription reports with the subscription report wizard.
  • Modified custom page in SharePoint designer to permit users kick off specific workflows based on user selections and privileges.
  • Attended various JAD sessions for the Data Center migration project and designed the whole process workflow for smooth migration of current infrastructure to new data center.
  • Experience in creating interactive process flow diagrams, network topology diagrams, AD group requirements document, pre and post cut over test strategy documents, installation documents etc.
  • Responsible for gathering AD groups requirement document and then creating scripts for assigning required access level to various database objects using AD group authentication.
  • Created all the new configuration scripts for post migration.
  • Created templates for routine changes.
  • Create and maintain users and roles, logins and assign privileges.
  • Experience in implementing different types of replication models like snap shot, merge and transactional.
  • Responsible for maintaining, updating, and using full, differential and transaction log backups and restoring database.
  • Experience in using SQL Server Profiler and Query analyzer for performance tuning of Indexes, Triggers and Stored Procedures etc.
  • Created build scripts for code promotion to SIT/QA/PROD environments.
  • Created various batch files using appcmd utility to modify the web server 2008 properties for successful hosting of asp.net website which was running on windows server 2003.
  • Experience in administration of windows server 2008 including IIS 7.0.
  • Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.

Environment: MS SQL Server 2008, SSIS, SSRS, T-SQL, Windows Sever 2008, Win 2003, SharePoint Designer 2007.

Confidential, Princeton, NJ

Business Data Analyst/SQL/ SSIS Developer

Responsibilities:

  • Designed Staging Database using Erwin.
  • Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server 2005 and Oracle 10g using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
  • Used SSIS packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
  • Generated Cubes to perform Analysis and created Fact and Dimension Tables.
  • Defined Referenced Relationships with the Measure Groups and Fact Tables.
  • Defined Dimension granularity within a Measure group and Drill through actions using SSAS.
  • Created Calculated Measures and Dimension members using Multi Dimensional Expressions (MDX).
  • Created various Parameterized Reports, Drill through Reports using SSRS 2005.
  • Generated ad hoc reports using MS Reporting services.
  • Reports were scheduled to be delivered by Email and File. Created Dashboard reports using SSRS.
  • Generated reports using SSRS that could be used to send information to different Primary vendors, Clients and managers.
  • Formed and developed the stored procedures, triggers to handle complex business rules, data conversion, historical data, and audit analysis.
  • Scheduled Jobs and Alerts using SQL Server Agent.
  • Implemented a well-planned backup and restore strategy that protects databases against data loss.

Environment: MS SQL Server 2005, SSAS, T-SQL, SSIS, SSRS, Erwin

Confidential, Jersey City, NJ

Business Data Analyst/SQL/ SSIS Developer

Responsibilities:

  • Involved in requirements gathering, analysis, design, development, change management, deployment and user training
  • Defined requirements and comprehended the complex business rules required for writing the code.
  • Involved in analysis, design, development, and enhancement of the data warehousing application.
  • Involved in all activities related to the development, implementation, administration and support of ETL processes for the Data Warehouse using, DTS and SSIS.
  • Worked on DTS and BCP to transfer data from legacy server to SQL server, to load flat file to SQL Server.
  • Created packages in SSIS, for data conversion using various transformation tasks
  • Transformed data from various data sources using OLE DB connection; also scheduled automated tasks.
  • Wrote complex MDX queries for calculated members and measure groups.
  • Created score cards with executive summary dashboards using Performance Point Server 2007 Dashboard Designer and deployed them to SharePoint server

Environment: SQL Server 2005, SSIS, ProClarity, TSQL, DTS, MOSS, C#.Net ASP.Net, ADO.Net, .Net Framework 3.5, UNIX shell script, Oracle 10g, Excel, Access

Confidential

Business Data Analyst/SQL/ SSIS Developer

Responsibilities:

  • Interacted with Business team to collect data for the conceptual design of the system.
  • Interacted with Development Teams and Managers to analyze business needs and developed technical specifications.
  • Merged Data from Heterogeneous Data stores (Oracle, Access and Excel) to SQL Server 2005 using SSIS packages.
  • Participated in to Design ETL architecture and processes insurance and policies related record from different locations. Successfully met challenges of very high volume of data.
  • Extensively used transformations, control flow tasks, data flow tasks, containers and event handlers.
  • Implemented the Indexing making the Transaction in SQL 2005 faster nearly three times as compared to the SQL Server 2000.
  • Experienced into Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups.
  • Wrote complex T-SQL queries, stored procedures, triggers, cursors and user defined functions (UDF’s).
  • Imported XML data file and put into the desired database.
  • Created and Executed the Stored Procedures and Complex Queries for Reports.

Environment: SQL Server 2000/2005, SSIS, SSRS, DB2, Oracle 9i, ASP, ODBC, VBScript, Windows 2000/XP, IIS 5.

Confidential

SQL Server Developer/ ETL Developer

Responsibilities:

  • Involved in requirements gathering, analysis, design, development, change management, developed backup restore scripts for MS SQL Server 2000 as needed.
  • Data Import/Export through DTS. Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Written T-SQL statements using DML and DDL for retrieval of the data. Configured data mapping between different Databases.
  • Query optimization using SQL Profiler and performance monitors to enhance the performance of database servers. Transformed data from various data sources using OLE DB connection by creating various DTS packages.
  • Experience in writing and debugging Stored Procedures and triggers. Designed, Developed and managed the reports using Reporting Services.
  • Performed Security issues related to logins, database users, and application roles and linked Servers.
  • Wrote scripts for generating Daily Backup Report, verifying completion of all routine backups, Log Space utilization monitoring etc.

Environment: MS SQL Server 2000 Enterprise Edition, Enterprise manager, MS Analysis Services 2000, MS Access 2000 & Windows 2000 platform, Reporting Services, Crystal Report 8.0, DTS, Windows Active Directory

Hire Now