We provide IT Staff Augmentation Services!

Bi Consultant Resume

AtlantA

SUMMARY

  • Over 7 plus years of IT Experience which includes analysis, design, development, testing and implementation of applications, reports and databases (MS SQL Server 2012/2008r2/2005/2000) in production environments.
  • Worked in multiple projects as BI Developer in Designing ETL Packages in development and implementation stages of teh Project according to client requirements.
  • Modified, maintained and developed teh SQL codes to develop new enhancements.
  • Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, FTP Task and Data Flow Task in Designing packages.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert and SQL Server Integration Services (SSIS).
  • Proven proficiency at Data Transformations like Lookup, Derived Column, Conditional Split, Sort, Data Conversion, Union All, Merge Join, Kimball SCD and OLEDB. Command to load data into SQL Server destination.
  • Develop and maintain teh documentation to support teh team and business.
  • Developed Reports in teh form of Matrix, Table, and Chart and linked Using SQL Server Reporting Services.
  • Modified, maintained and developed teh reports using SQL Server Reporting Services.
  • Developed role based security for reports.
  • Proficient experience in Functionality Testing, SQL Database Testing.
  • Proficiency in System Integration Testing (SIT), Operational Readiness Testing (ORT), User Acceptance Testing (UAT), Regression Testing and other test levels.
  • Excellent noledge and working experience in Test Planning, Test Preparation, Test Execution, Test Results analysis, Defect life cycle management, Debugging, Test Results Documentation and Release activities.
  • Good exposure to V - Model, Agile methodologies. Created Master Test Plan Document.
  • Uploading teh scripts to MTM (Microsoft Test Manager) Tool and Creating Bugs in VSTF.
  • Verifying teh code in packages and validating teh report.
  • Good noledge in SQL Server 2008.
  • Good noledge on data warehousing concepts.
  • Good in designing, developing and maintaining data models.
  • Good communication, inter-personnel skills and good team player. Self motivated individual wif strong analytical and problem solving abilities, Proactive, Dedicated, enjoy learning new technologies and willing to take on extra responsibilities to get work done.

TECHNICAL SKILLS

Database: Oracle-10g, 11g, MS SQL Server 2008,2008R2,2012, MySQL

Programming Language: SQL, PL/SQL

ETL Tools: Microsoft Business Intelligence, Informatica Power Center 9.x,Informatica Data Quality

Operating System: MS-Windows Server2000,2008,2012, XP,7 Windows NT, UNIX and LINUX

PROFESSIONAL EXPERIENCE

Confidential, Atlanta

BI Consultant

Environment: SQL Server 2012/2008 R2/2008, SSIS, SSRS, Visual Studio 2012, WINDOWS7

Responsibilities:

  • Extensively involved in interacting wif teh business users and gathering teh requirements for teh data warehouse.
  • Analyzed teh requirements and provided best possible solutions.
  • Created project plan and a business requirement document and presented it to teh client for their review.
  • Creating teh complex stored procedures, user defined functions to meet teh business rules.
  • Converted teh data mart from Logical design to Physical design, defined data types, Constraints, and generated Schema in teh Database.
  • Optimized teh database by creating various clustered, non-clustered indexes and indexed views.
  • Creating, loading, and modifying a new package or an existing package or add and configure components, making changes object by using Control Flow Tools and Data Flow Tools and then verify it.
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
  • Developed reports using SSRS and published as PDF, Excel, and CSV formats.
  • Involved in Unit testing integrated testing and System testing.

Confidential, Florida

ETL Developer

Environment: SQL Server 2012/2008 R2/2008, SSIS, SSRS, Visual Studio 2012, WINDOWS7 Oracle 10g, Windows Server 2008, Flat files

Responsibilities:

  • Understand teh business model in moving data from legacy source to Siebel systems.
  • Implement logic to construct teh staging area by analyzing business requirement and configuring Packages to load data into Siebel wif precision.
  • Designing teh staging area structure for capturing teh extracted business data from teh legacy system.
  • Involved in loading different entities into Siebel base tables (Group, Member, Invoice, Product, Agency, Contact, Address, Activity, Note, Attachment, LOV etc.)
  • Worked as business data analyst understanding teh business need and actively participated in configuring teh ETL using PowerCenter for data migration from legacy application to Siebel database.

Confidential

Senior Developer

Environment: SQL Server 2012/2008 R2/2008, SSIS, SSRS, Visual Studio 2012, WINDOWS7

Responsibilities:

  • Interacting wif teh business users/stakeholders to clarify requirements.
  • Monitoring teh jobs and troubleshooting them if teh job fails.
  • Processing teh files given by client on monthly basis and sending them teh report.
  • Working on change requests raised by client.
  • Addition of new MCO’s as per client requirement.
  • Verifying teh code in packages and developing reports.

Confidential

Senior Developer

Environment: SQL Server 2012/2008 R2/2008, SSIS, SSRS, WINDOWS8

Responsibilities:

  • Requirement analysis, understanding functional/technical specifications documents provided by business and attending calls wif solution designers on teh same.
  • Identified teh KPI’s as per teh business.
  • Created schema for teh project.
  • Created SSIS packages to load teh data into dimension and fact tables. Done Unit Testing.

Confidential

Senior Developer

Environment: SQL Server 2012/2008 R2/2008, SSIS, SSRS, WINDOWS8

Responsibilities:

  • Requirement analysis, understanding functional/technical specifications documents provided by business and attending calls wif solution designers on teh same.
  • Verifying teh reports available in Report Manager and validating them wif backend.
  • Verifying teh code in packages and validating teh report.
  • Interacting wif teh business users/stakeholders to clarify requirements.
  • Creating Master Test Plan Document for users.
  • Creating SIT Test Scripts.
  • Uploading teh scripts to MTM (Microsoft Test Manager) Tool.
  • Creating Bugs in VSTF.
  • Conducting daily sync up meetings on open defects wif onsite issue resolution managers.

Hire Now