PROFESSIONAL SUMMARY:

• 7+ years of experience in the role of a Microsoft Business Intelligence Developer in the following:
• Business Intelligence experience in Development, Client Analysis, Database Design, Reporting, and Presentation using SQL Server versions, SSIS, SSAS and SSRS.
• Proficient in building end to end data integration and workflow solutions from input source extraction, using various transformations and data load from development studio (BIDS/SSDT).
• Experience in handling different type of data like OLTP, OLAP, Excel and XML and Flat files.
• Implement Business intelligence logic using different languages such as DDL, DML, DCL and User defined functions and expressions.
• Experience in managing alerts, operators and jobs through SQL Server Agent.
• Expert in building and designing SSIS packages involving the ETL process, extracting data from various Flat files, Excel files, XML files, SQL Server and loading into various Flat file, Excel and OLAP destination in SQL Server.
• Expert in the use of SSIS Control Flow components such as Foreach Loop Container, Sequence Container, Execute SQL Task, File System Task, Data Flow Task, Script Task, Send Mail Task and SSIS Data Flow components such as Conditional Split, Data Conversion, Derived Column, Union All, Merge and Merge Join, Sort, Slowly Changing Dimension, Lookup and Multicast.
• Expertise in creating, deployment and distribution of chart reports, tabular reports, matrix reports, drill down reports, parameterized reports, cascading reports, conditional formatting, drill - through reports, sub reports and dashboards
• Experience in Data warehousing, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.
• Experience in uploading files to a Report Server Catalog from the Report Manager and deploying reports via Native mode and Web Services.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects
• Followed Agile Methodology to keep track of projects and maintained schedule by being an active participant of daily scrums and bi-weekly sprint
• Experience in using Cube Analysis to create reports in SSRS
• Expertise in Objects creation such as Tables, Stored Procedures, Triggers, Constraints, User Defined Functions, System Functions, Views, Indexes, SQL joins and query writing.
• Experience in Data warehousing, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.
• Expert in using performance tuning tools like MS SQL Profiler, Tuning Advisor and Execution Plan
• Experience in Normalizing and De-normalizing tables and maintaining Referential Integrity by using Primary Keys, Foreign Keys, Unique Keys and Checks
• Experience working in both OLTP and OLAP environments
• Experience in Error handling through TRY-CATCH statement, Common Table Expression
• Experience in handling the Isolation Levels
• Configured SMTP Server for Database Mail setup
• Expert in the Development, Deployment and Troubleshooting of SQL Server Reporting services reports
• Expert in the creation of data driven subscriptions for reports, linked reports, snapshots, report caching and ad-hoc reports
• Expertise in the creation, deployment and distribution of chart reports, tabular reports, matrix reports, drill down reports, parameterized reports, cascading reports, conditional formatting, drill-through reports, sub reports and dashboards
• Experience in uploading files to a Report Server Catalog from the Report Manager and deploying reports via Native mode and Web Services
• Experience in granting and revoking end user access to reports, assigning roles to users and periodically reviewing them to make sure they are operating correctly
• Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration reports and linked reports on a Weekly, Quarterly and Yearly basis and random ad-hoc reports using SQL Server Reporting Services (SSRS) for various in-house users
• Creating and maintaining various subscriptions in the Report Manager for the reports

TECHNICAL SKILLS:

DBMS/RDBMS: SQL Server 2012/2014/2016/

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Import/Export wizard, Data Transformation Services (DTS) and Data stage

Report Tools: SQL Server Reporting Services (SSRS)

Data Modeling: SQL Server Analysis Services (SSAS)

Languages: T-SQL, PL/SQL

Operating System s: Windows server 2008/2003/XP/98/Vista, Windows 7/8

Query Tools: SQL Server Management Studio (SSMS)

Office Tools: MS Word, PowerPoint, Excel and Visio

Domain Expertise: Healthcare, Telecom, Retail and Financial, Social media

Source Control: Team foundation server 2010 (TFS)

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server SSIS/ETL/ BI /Application Developer

Responsibilities:

• Used SSIS to create ETL packages as an ETL tool.
• Do reverse engineering on VB and windows applications to redirect source data
• Develop SSIS packages using best practices to extract data from csv files, transform and ingest the data into Olap destination.
• Actively participated in Transforming and moving data in an EDW project
• Designed high level ETL architecture for overall data transfer from the source server to the destination server which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata using SSIS.
• Excellent in data staging and data warehousing
• Created Log Files to troubleshoot package failure errors.
• Responsible for maintaining and scheduling packages.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata using SSIS.
• Worked with a combination of multiple Dataflow Transformations to build packages in SSIS.
• Troubleshooting of processes, issues and errors in SSIS Packages to improve their performance.
• Interacted, retrieved, and analyzed business requirements.
• Produced parameter driven, matrix, sub-reports, and integrated report hyperlink functionality to access external applications.
• Scripting/moving of databases across different environments
• Created unique data driven email subscriptions within report manager.
• Created clustered and non-clustered indexes on tables for new database for faster retrieval of data for the Reports.
• Perform source control and find a doc using different developer tools.
• Write SQL queries and stored procedures to generate data for reports and data to populate in house applications.

Confidential

SQL Server BI/SSRS/SSAS/SSIS/BI/ETL Developer

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification.
• Designed high level ETL architecture for overall data transfer from the source server to the destination server which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata using SSIS.
• Developed SSIS Packages to load data into database and flat file using SSMS
• Responsible for creating SSIS packages which extract data to single flat file from different data-source. Created Log Files to troubleshoot package failure errors and maintaining and scheduling packages.
• Created and designed OLAP cubes and wrote MDX queries for calculating cube data using SQL Server 2005 Analysis Services (SSAS) and developed drilldown reports using (SSRS)
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Created SSIS packages to load customer information from flat file.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata using SSIS.
• Worked with a combination of multiple Dataflow Transformations to build packages in SSIS.
• Troubleshooting of processes, issues and errors in SSIS Packages to improve their performance.
• Interacted, retrieved, and analyzed business requirements.
• Produced parameter driven, matrix, sub-reports, and integrated report hyperlink functionality to access external applications.
• Landing of packages from various sources to Development Environment.
• Created unique data driven email subscriptions within report manager.
• Created clustered and non-clustered indexes on tables for new database for faster retrieval of data for the Reports.
• Responsible for elevating and automating successful code to production environment
• Wrote SQL queries and stored procedures to generate data for reports.

SQL Server BI/SSIS ETL administrator/ SSRS Reporting Specialist/SSAS/OLAP, OLTP

Confidential

Responsibilities:

• Created advanced T-SQL queries using DDL, DML and Indexes, Views, Cursors, Triggers,
• Created schema objects, rules and granted roles to the users
• Used SQL Profiler to debug T-SQL and slow running queries
• Designed and implemented Parameterized and cascading reports using SSRS
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Experience performing database Backup and Recovery
• Involved in performance tuning of T-SQL queries and Stored Procedures
• Implemented Auditing using triggers
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Involved in creation of various dashboard used for reporting to the end user.
• Identified and worked with Parameters for parameterized reports in SSRS 2012.
• Generated the drilldown, drill through and linked reports using the SSRS.
• Set up & configured DB mail and created jobs to send out an email whenever any SQL jobs fails.
• Participated in AGILE iterative development methodology.
• Work with Report analysts and operation staff for support in problem resolution and root cause analysis.
• Implemented various types of SSIS Transformations in Packages including Slowly Changing Dimension, Aggregate, Lookup, Conditional Split, Data Conversion, Row Count, Derived Column etc

BI DEVELOPERSQL SERVER BI/SSIS/ETL/SSRS

Confidential

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification.
• Designed high level ETL architecture for overall data transfer from the source server to the destination server which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata using SSIS.
• Developed SSIS Packages to load data into database and flat file using SSMS
• Responsible for creating SSIS packages which extract data to single flat file from different data-source. Created Log Files to troubleshoot package failure errors and maintaining and scheduling packages.
• Created and designed OLAP cubes and wrote MDX queries for calculating cube data using SQL Server 2005 Analysis Services (SSAS) and developed drilldown reports using (SSRS)
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Created SSIS packages to load customer information from flat file.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata using SSIS.
• Worked with a combination of multiple Dataflow Transformations to build packages in SSIS.
• Troubleshooting of processes, issues and errors in SSIS Packages to improve their performance.
• Interacted, retrieved, and analyzed business requirements.
• Produced parameter driven, matrix, sub-reports, and integrated report hyperlink functionality to access external applications.
• Landing of packages from various sources to Development Environment.
• Created unique data driven email subscriptions within report manager.
• Created clustered and non-clustered indexes on tables for new database for faster retrieval of data for the Reports.
• Responsible for elevating and automating successful code to production environment
• Wrote SQL queries and stored procedures to generate data for reports

SQL SERVER SSIS/ETL SSAS DEVELOPER

Confidential

Responsibilities:

• Created advanced T-SQL queries using DDL, DML and Indexes, Views, Cursors, Triggers,
• Created schema objects, rules and granted roles to the users
• Used SQL Profiler to debug T-SQL and slow running queries
• Designed and implemented Parameterized and cascading reports using SSRS
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Experience performing database Backup and Recovery
• Involved in performance tuning of T-SQL queries and Stored Procedures
• Implemented Auditing using triggers
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Involved in creation of various dashboard used for reporting to the end user.
• Identified and worked with Parameters for parameterized reports in SSRS 2012.
• Generated the drilldown, drill through and linked reports using the SSRS.
• Set up & configured DB mail and created jobs to send out an email whenever any SQL jobs fails.
• Participated in AGILE iterative development methodology.
• Work with Report analysts and operation staff for support in problem resolution and root cause analysis.
• Implemented various types of SSIS Transformations in Packages including Slowly Changing Dimension, Aggregate, Lookup, Conditional Split, Data Conversion, Row Count, Derived Column etc