SUMMARY

• 9+ years of experience in Data modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database Systems using MS SQL Server
• Intense and in-detail work experience in eclinicalworks, One of the leading cloud based ELECTRONIC HEALTH RECORDS(EHR) as a SQL Developer.
• Have Hands-on Experience in dealing with financial regulations Dodd Frank, CCAR, Basel, Mifid, Vockler etc in Confidential .
• Worked in Confidential, which is one of the world’s largest investment group and my role in that company has been into Asset management.
• Experience in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2016/2012/2008
• Extensive experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS,SSIS,SSAS) using MSSQL Server 2000/20
• Expert in providing Enterprise Reporting solutions using SSRS 2000/2005/2008 , Crystal Reports Suite (9/10)
• Worked with Web Viewer app for the video-call meetings.
• Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads
• Extensive Experience in Microsoft .Net Technologies using .Net Framework 1.1,2.0/,C# (.Net), VB.Net, ASP.Net.
• Utilized Integration Services (SSIS) to produce a Data Mapping and Data Mart for reporting.
• Developed Drill through and Drill downreportsusing SQL Server Reporting Services (SSRS).
• Expertise in designing Dashboards & Scorecards for quick review for business users of different user classes from Cognos Connection.
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Integration of Tempo Time Tracking Tools in JIRA .
• Involved in writing Complex Queries, heavy stored procedures, Batch Scripts, Triggers, Functions using T-SQL
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities
• Involved in scheduling jobs, address Batch process issues, Debug code and Maintenance and bug fixes.
• Test & Deploy code across various SDLC Environments like TEST, UA/UT/Production.
• Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2000/2005/2008 across various environments
• Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems
• Expertise in Enterprise Reporting in generating reports using linked reports, sub reports and filters, charts in SQL server reporting services.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Experience in Integrating SQL Server Reporting Services with Microsoft Office Share Point Server (MOSS).
• Extensive knowledge in ETL Process & Progressive knowledge
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, BCP & Bulk Insert utilities
• Expertise in designing SQL Server DTS packages to import and transform data between databases and external data sources.
• Involved in migration of DTS Packages (2000) to SSIS (2005/2008/2012 ) and troubleshoot migration issues.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for DTS Packages.
• Experience in Performance Tuning in DTS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
• Excellent communication and interpersonal skills and has ability to handle multiple tasks; can take initiative to handle responsibilities independently as well as a proactive member of a team.

TECHNICAL SKILLS

Operating Systems: Windows Vista/ XP/ 2003/ 2000/ NT 4.0/ 9x, MS-DOS

Programming Languages: T-SQL, PL/SQL, MDX, C, VB Script, C# .NET, VB .NET

Web Technologies: HTML, XML, XSL, JavaScript, IIS (4.0/5.0/6.0)

Databases: Microsoft SQL Server 2012/2008, MS-Access 97/2000/2003 Oracle 9i/10g

Tools: /Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Visual SourceSafe 6.0, Visual Studio .Net, Microsoft Management Console, DTS, SSIS, Business Intelligence Development Studio (BIDS), Crystal Reports 9.0, ETL

Database: Design Tools MS Visio, Erwin

Configuration: Clear Case, Clear Quest, Visual Source Safe

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS)

Application Packages: MS Office, Ms Outlook (Microsoft Office Suite) Portal SharePoint Portal Server 2003, Windows SharePoint Services

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

Power BI Developer/SSRS/SSIS Developer

Responsibilities:

• Involved in project planning, gathering requirements from the users, creating spec and layout of the report.
• Improved the performance of SQL by tuning the Stored Procedures and TSQL queries using various join conditions. Generate experience in converting Actuate reports into SSRS. Created XML, PDF, EXCEL files.
• Expertise in Desktop creating and integrating Microstrategy reports, objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) and Generic,Pivot cubes.
• Installing and Configuring of Micro Strategy suite including Micro Strategy Desktop, Administrator, Intelligence Server, Web, and Narrowcast Server on NT Servers and Sun Solaris Environments.
• Experience of non-Microsoft .NET technologies including JQuery and Oracle.
• Specific responsibilities for the Maintainer, based on Business Processes, focus for data ownership.
• Links Master Data Management activities and hence master data objects.
• Experience providing training to development teams on how to track, plan and analyze using JIRA.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Expertise in providing security to the reports in COGNOS connection and producing reports in different format such as PDF/Excel/XML.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in actuat..
• Developed appropriate layout and designs for required reports using the SSRS and Stored procedures to retrieve data from the SQL Server using appropriate SQL language (PL/SQL, T-SQL) to provide optimal performance.
• Create and Maintain Teradata Tables, Views, Macros, Triggers and Stored Procedures.
• Involved in package migration from DTS to upgrade advisor against DTS
• Extensively involved in designing the DTS packages to export data of flat file source to SQL Server database.
• Optimize various SQL queries to make thereportsrun faster.
• Create test data by creating views/procedures for reporting purpose.
• Optimized the configuration of Amazon Redshift clusters, data distribution, and data processing
• Working on performance and cost efficient solutions in AWS cloud to suit application specific needs.
• Exportreportsin various formats like MS Excel, PDF, MS Word, Text and CSV.
• Create nested, conditional subgroups and formatting features inreports.
• Create Subreportscalled from the mainreportto implement the business logic.
• Create various database objects like Tables, Views and Stored Procedures by using Toad.
• Responsible for defects raised during testing of thereports.
• Assist UAT team in testing thereportsusing SQL queries in TOAD, SQL developer and Win SQL and advise them with necessary changes.
• Hands on technology experience of designing and developing software applications withMicrosoft .NET Framework 1.0/1.1/2.0/3.0/3.5 using C#, ASP.NET and ADO.Net.

Environment: XI 3.1, 4.0, IDT, Oracle 10g/9i, PL/SQL, Teradata, SQL Developer, Win SQL, UNIX, Windows XP.

Confidential, Washington D.C

SSIS/Power BI Developer

Responsibilities:

• Responsible for gathering and defining user report requirements and developing appropriate interfaces for the reporting infrastructure environment to meet customer business needs, based on business processes and data entities between various systems.
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually
• Developed, monitored and deployed many SSIS packages
• Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler.
• Developed appropriate layout and designs for required reports using the SSRS and Stored procedures to retrieve data from the SQL Server using appropriate SQL language (PL/SQL, T-SQL) to provide optimal performance.
• Worked on server Migration of databases, Permissions, Logins, SQL jobs, SSIS Packages, from one server to another server and preparing the corresponding document for other environments.
• Created Tabular reports, Matrix reports, List reports and Sub reports using SSRS.
• Involved in Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Report Models Drill Down Reports
• Designed and developed the reports according to the requirements using Tableau and Power Map.
• Used Conditional Formatting to change the behavior of the report depending on the requirement.
• Developed various Custom Code functions using VB Script.
• Deployed the SSRS Reports to the report server and maintained them.
• Migrated and Converted over 200 Crystal Reports to SQL Server Reporting Services (SSRS).
• Experience with Data Accessing including usingData Adapter, Data Reader and Dataset in ADO.NET and LINQ (Language Integrated Query) Providers for data manipulation.
• Migrated ofclassis ASPapplications toASP.NetandC#,MS AccesstoSQL Server.

Environment: SQL Server 2008 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Microsoft Visual studio 2008, Oracle 10g, Crystal Reports, PL/SQL, T-SQL, XML, Microsoft Visual Source Safe, TFS (Team Foundation Server), Subversion, Pivotal Tracker, MS Access 2003 & Windows Server 2003, VB Script.

Confidential, Westborough, MA

Power BISSRS/SSIS Developer

Responsibilities:

• Loaded legacy source data from MSSQL, MySQL, Oracle, Access, and SQL Server DB’s into SQL Server 2008 R2 staging DB’s using SSIS Import &Export Wizard and VB scripts, SQL Server Migration Assistant (SSMA) and SSIS packages.
• Extensive experience inPythonweb frame works like Django, Pyramid and Flask in implementing MVC architecture.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Maintaining and supporting the existing reports as per the requirements in the customer support portal. Worked on Maintaining, Generating Reports and Data Migration for various Hospital Database systems using SQL Server 2008, SSRS, SSIS, MySQL and vb.
• Participate in creating data conversion and migration strategy, conversion design and conversion development documents. Participate in Data Modeling Sessions. Hosted SSIS, SSRS knowledge transfer, data quality issue meetings with the client on a weekly/biweekly basis.
• Improved the performance of SSRS reports by tuning the Stored Procedures and TSQL queries using various join conditions. Generate experience in converting Actuate reports into SSRS. Created XML, PDF, EXCEL files using SSRS.
• Created stored procedures and SQL statements for generating Ad-hoc Reports in SSRS. Used dynamic connection managers using SSIS expressions to load data from 25 databases into a single DB.
• Deployment of SSIS packages to the conversion server and create and schedule SQL Server Agent jobs to automate the run of SSIS packages on a weekly basis. Experience in creating master and child packages, using package configurations (XML, SQL Server) and SSIS logging.
• Performed SQL Server DBA tasks like Conversion DB backups using compression, restore and disk space management on the conversion server, disabling and enabling constraints and triggers, applying DB Change requests, lookup data changes in corporation, logins & permissions. Created linked servers to write validation queries against the source and target present on different servers.
• Involved in the entire conversion lifecycle stages of Requirement Analysis, Data Profiling, Logical and Physical Data Mapping, Strategy, design, development, Unit testing, conducting conversion mock runs to provide data for the Development DB, SIT, UAT, Data Reconciliation and validation.
• Documentation of Business Rules, Data Mapping Spreadsheet, Meeting Minutes, Key decisions from the client, SSIS and SSRS introduction material to the client.
• Worked with Managers to prepare requirements gathering documents and quality documents.

Environment: SSIS 2008/2012,BIDS,SQL Server 2008R2, T-SQL, Visual Basic .Net, Vb6, XML, eManager, eBO reporting, Microsoft Project, SVN, Core Java, Microsoft Access, SSRS, Microsoft Excel, QAS.

Confidential, NYC, NY

Power BI/SSIS Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• Applied knowledge of Normalization and De-Normalization techniques.
• Writing queries to create stored procedures, User Defined Functions, Views, Triggers and CTEs (Common Table Expressions).
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc).
• Writing Complex T-SQL Queries, Sub queries, Co-related sub queries and Dynamic SQL queries.
• Performance tuning of Stored Procedures and T-SQL Queries.
• Involved in a extremely broad piece of legislation seeking to comprehensively address the gaps in regulation revealed by the 2008 financial crisis like Dodd Frank.
• Worked with Basel accords (Basel 1, 2, and 3) are international standards for capital and liquidity adequacy of banks. Basically, they seek to set common standards for measuring the riskiness of banks' balance sheets.
• Dealt with CCAR which is the annual "stress test" applied by the Federal Reserve to the largest American bank holding companies.
• Involved in Vockler rule which deals effects acquiring or retaining any equity, partnership, or other ownership interest in a hedge fund or private equity fund.
• Have idea on MiFID which is a Approved Reporting Mechanism(ARM) transaction reporting means that UnaVista is well placed to assist you with meeting your periodic reporting obligations
• Created logins, users and configuring permissions and assigning roles to users.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used SQL Server 2005 to design, implement and manage data warehouses OLAP cubes and reporting solutions to improve asset management, incident management, data center services.
• Created SQL scripts for tuning and scheduling.
• Performed data conversion from flat file into a normalized database structure.
• Created new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Involved in Deployment and Administration of SSIS packages with Business Intelligence development studio.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Generated reports using SSRS and Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Responsible for creating the reports based on the requirements using SSRS 2008.

Environment: MSSQL Server 2008, SSIS, SSRS, BIDS, Visual studio 2008, MS Visio 2007 and XML.

Confidential, Charlotte, NC

SSIS/SQL Server Developer

Responsibilities:

• Involved in all the phases of SDLC.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various types of Constraints and Triggers for Data Consistency.
• Used Stored Procedures for updating Servers.
• Used DDL and DML Triggers, Stored procedures to check the Data Integrity and verification at early stages before calling them.
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Ware House.
• Developed, deployed and monitored SSIS Packages. Involved in creating log files for SSIS packages.
• Created SSIS Package configurations for executing in different environments.
• Enabled Check points in SSIS package. Created break points in order to view the status of data, variables and over all status of SSIS package.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Developed and Deployed different types of Reports like List, Matrix, and Chart and Sub Reports etc.
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created/ Maintained clustered/ non clustered Indexes for fast and efficient reporting process.
• Used SSRS to create interactive reports with an ability to drill down into details.

Environment: .NET 3.0, MS SQL Server 2005, SSIS, SSRS, T-SQL,Visual Studio 2005, MS Office 2003, SQL Profiler, Windows 2003/2008.

Confidential

SQL Developer

Responsibilities:

• Administered and enhanced SQL Server Reporting Services (SSRS).
• Being a member of BI development and reporting team, involved in writing lots of reports incorporating business logic and user requirement.
• Involved in building huge number of reports using multivalve, single valued and dependent parameters.
• Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler.
• Developed reports using complex TSQL queries, User Defined Functions, store procedures and Views
• Involved in Installation, Configuration of SSRS Reporting server and involved in Deploying reports.
• Used VB.Net, VB Scripts for loading data using SSIS Packages.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Involved in designing sub reports and linked reports depending on the user requirement and in order to limit the number of Data Sources.
• Involved in building huge number of reports using multivalve, single valued and dependent parameters.
• Involved in Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Report Models Drill Down Reports
• Involved in writing C# scripts for script task in SSIS.
• Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS
• Deployed reports across Test, Development and Production Environments

Environment: T-SQL, PL/SQL, MS SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS), Windows XP, Crystal Reports 9.0, Oracle9i, C#.