SUMMARY

• 7+ years of experience of IT experience in Analysis, Design, Modeling, Development, Testing and Maintenance of Business Intelligence Applications.
• I have worked in different domains such as Finance, Healthcare learning Solutions, and Retail.
• Using different versions of Microsoft SQL Services (SSMS, SSRS, SSIS, and SSAS) related tools.
• Highly expert in translating Business System Design document into technical design document
• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
• Expert in Design, developing and maintaining SSRS reports
• Expertise in creating Ad - hoc, Cascading Parameterized and Parameterized reports involving Drill down, Drill through features with Matrix, Chart and Sub reports using SSRS.
• In-depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins.
• Experience in scheduling SSIS packages using SQL Server Agent.
• Strong knowledge of using variables and expressions in packages.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Expertise in the designing, developing, and deploying SSIS packages using various control flow tasks and data flow transformations like conditional split, derived column, look up, merge, sort etc.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Expert in resolving the performance issue of SSIS packages.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, and XML).
• Strong experiences to Design, deploy, and maintain various SSRS Reports in SQL Server 2012.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, Pie Charts, and column report.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

TECHNICAL SKILLS

Databases: MS SQL Server 2012/2008R 2/2008/2005/2000 , Oracle 8i/9i/10g, MS-Access 97- 2007

Operating Systems: Windows 2008/2000/2003 Advanced Server, Windows NT 4.0 / 3.51, Windows 3.x, Windows 9.x, Windows 95/98/XP.

ETL Tools: SQL Server Integration Services (SSIS) 2005/2008, Data Stage, DTS, SQL Server Reporting Services (SSRS), Crystal Reports 8/10, SQL Server Analysis Services (SSAS)

Web Technologies: HTML, DHTML, XML, Visual Studio, MS Front

Programming languages: C, c#, VB.NET, Visual Basic for Applications (VBA) and ASP.NET, SQL, PL/SQL

Other Tools: Microsoft Office 2003/2007, MS Project 2000, Toad, SQL Loader, DB visualize, Erwin, Microsoft Visio 2000/2003.

PROFESSIONAL EXPERIENCE

SQL/SSIS/SSRS/T-SQL Developer

Confidential, Dulles, VA

Responsibilities:

• Created databases and schema objects including tables, indexes, and applied constraints, connected various applications to the database and written functions, stored procedures, and triggers.
• Proficient in usage of SSIS Control Flow items (For Loop, execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Having first-hand experience in DR Processes including Log shipping and Database Mirroring.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• First-hand experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions, and package configurations.
• Created SSIS/DTS packages to copy tables, schemas, and views and to extract data from Excel and Oracle.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing various kinds of transformations using SQL Server Integration Services (SSIS).
• Implementing all high availability techniques like clustering, log shipping, replication.
• Working experience with Column store indexes, table partitioning in SQL SERVER 2012.
• Working experience with in-memory concepts of OLTP databases in SQL SERVER 2014.
• Designed prominent level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2008/2012) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2008/2018.
• Also, went through query execution plans, sql profilers and did query optimization.

Environment: Windows2003 Advanced Server, ASP.Net, MS SQL Server 2008/2012/2014 , TSQL, Pl/SQL, SSRS, SSIS, OBIEE, Informatica, Erwin.

Confidential, Philadelphia, Pennsylvania

MSBI/Report Developer

Responsibilities:

• Gathering the Business Requirements from the Business Users and performing an extensive Data Analysis on the internal host system.
• Understood the requirement specifications, prepared the functional and technical design documents.
• Creating functional, technical design, and data mapping documents by interacting with customer's subject matter expert (SME).
• Determined and wrote SQL quires and reviewed data to ensure data integrity, accuracy, and validity.
• Identified data quality issues and worked with appropriate teams to resolve them.
• Extracting data from multiple sources like flat files and SQL server and transforming, cleansing, validating data, and loading it into the destination.
• Developed new mapping documents and used transformations like Look Up, Aggregation, Derived Column, Data Conversion, etc., to match the business case's needs.
• Performed Ad-hoc Reporting functions for special needs and requests, Designed and formatted Data Reports utilizing T-SQL
• Developed reports (Table, Matrix reports, Chart, drill down, Drill through, Parameterized, Cascading, Conditional, Dashboard, and Sub Reports, etc.) used by management group and clients to retrieve information.
• Used Execution Plan, SQL Profiler, and database engine tuning advisor to optimize queries and enhance databases' performance.
• Used T-SQL for creating various complex objects like Tables, views, functions, stored procedures for storing and processing data in the required form.
• Extensively used Impala SQL for Query parallel processing database.
• Designed ad-hoc reports and complex enterprise reports, including drill down, drill through reports, cascading reports, sub-reports, linked reports using SSRS.
• Experience designing, developing, and maintaining custom SSRS reports and Provide reporting to customers and management to support business decisions.
• Used Visual Studio and SQL Server Report Builder to modify or enhance an extensive repository of existing SSRS reports and develop new SSRS reports from data in replicate.
• Design and develop user-friendly dynamic reports and dashboard using parameter, expression, conditional formatting, and grouping to reduce ongoing ad hoc requests
• Hands-on experience in developing reports and dashboards using Power BI Desktop and publish them to Power BI services and Power BI Report Server.
• Clean and transform data in Power BI Query editor.
• Utilized Power BI gateway to keep dashboards and reports up to date with on premise data sources.
• Build calculated fields in DAX (Data Analysis Expression) for necessary reports and analysis
• Administered Power BI admin portal to manage Office 365 and Tenant Setting; Run Capacity usage matrix data to capture usage information and track reports and dashboard usages in Power BI.
• Manage users' interactions in Power BI tenant by creating a dashboard using activity log Data for Power BI Administrators to know who does what, at what time, and other activities.
• Implement the full cycle of power BI visualizations such as extracting and transforming data in Power Query, designing various visualizations in Power BI desktop, publishing reports into Power BI Services, and developing and managing dashboards
• Perform data analysis with appropriate programming and analytic methodologies; present data or reports in a meaningful fashion; work collaboratively with teams and leadership; formulate recommendations for further initiative refinement based on current data evidence.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions, and deploying analysis services projects.

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Impala SQL, Agile, Multi Dimension, Cubes, Tabular Modeling, Management Studio, Data Transformation Services, Visual Studio, MS Access, T-SQL, Power BI.

Confidential, Arlington, VA

Senior SQL /ETL/SSRS /SSIS Developer

Responsibilities:

• Developed Stored Procedures, Tables, Views, and SQL Join statements for applications by using T-SQL and PL/SQL scripts.
• Used SSIS and T-SQL Stored procedures to transfer data from source databases to a staging area and finally transfer into a data warehouse.
• Took Database Full Backup, Transaction log backup, and differential backup in a daily routine.
• Developed and deployed data transfer packages to the appropriate destinations using SSIS.
• Used SSIS transformations to implement Slowly Changing Transformations and to maintain Historical Data in a Data warehouse.
• Created packages using various Control flow Elements such as Data Flow task, Execute SQL task, Execute Package task, File System task, For Loop Container, For each Loop Container and more.
• Performed maintenance of Stored Procedures to improve the Performance of different front-end Applications and scheduled SSIS packages using SQL Server Agent.
• Extracted data from various sources (CSV files, oracle, and MS SQL 2000) and stored data into intermediate Staging Database using the SSIS ETL tool.
• Applied several required transformations using Data Flow Task in a Staging Database and made the data ready to load into a cloud-based data warehouses (Azure, AWS) and on-premises hybrid data warehouses.
• Implemented and managed continuous delivery systems and methodologies on AWS
• Deployed big data solutions in the cloud. Built, configured, monitored, and managed end to end big data applications on AWS
• Designed high-level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse and created SQL server configurations for SSIS packages.
• Scheduled Reports to run on a daily and weekly basis in Report Manager and email them to director and analysts to review in Excel Sheet.
• Used SSIS jobs for importing data from flat files sources to the application tables.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Integrated various Data Sources like SQL Server, MySQL, Oracle 11g/10g/9i/8i, DB2, MS Access into a Staging area then to Azure Data warehouses.
• Developed Unix shell Scripts to mechanize sending data through Connect Direct to the process center.
• Performed maintenance duties like Performance tuning and Optimization of Queries, Functions, and Stored procedures; Monitored and improved Performance using execution plans and Index Tuning.
• Customized Team Foundation Server as per project requirementsand generated TFS reports to serve company needs.Integrated TFS add-ins called Aggregator to ensure automation.

Environment: MS SQL Server 2016, T- SQL, Oracle 12c, MS Excel 2013, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Visual Studio 2019, Informatica, TFS.