SQL Developer with BI & Automation Expertise
Resume:
SQL Developer
Pratap Vardhan Pasam
************@*****.***
https://www.linkedin.com/in/prathap-p-214921126/
PROFESSIONAL SUMMARY
• SQL Development professional with around 11+ years of experience in database and business intelligence technologies with expertise on ETL process and Reporting using SQL server SSIS, SSRS and Tableau.
• Strong experience in requirement analysis, physical and logical design development, resource planning, coding, debugging, testing, support, and maintenance of business intelligence applications using SQL Server 2008/2012/2014/2016/2019 DTS, SQL Server Integration, Analysis and Reporting Services
• I have PowerShell experience for more than 3 years in developing PowerShell scripts for automating various tasks. I have a strong background in Windows administration and have a keen interest in automating tasks to improve efficiency.
• I have experience in developing PowerShell scripts for Active Directory, Exchange, and SharePoint. I have also developed scripts for automating various tasks such as user provisioning, email archiving, and file share management. I am familiar with PowerShell cmdlets and have a good understanding of how to use them. I am also familiar with PowerShell remote and have a good understanding of how to use it for managing remote servers.
• I am also well-versed in using PowerShell for Active Directory administration. I have used PowerShell to automate various tasks such as user creation, group management, and OU management.
• Extensive work experience in SQL by writing Packages, Stored Procedures, Cursors, Functions, Views, Database Triggers, User-Defined Types, Dynamic SQL, and SQL Server Management Studio
• Expert in writing T- SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Experience in using recursive CTEs, CTE, Temp tables and effective DDL/DML triggers to facilitate efficient data.
• Intensive experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor
• Experience in query optimization performance tuning. Used SQL Profiler, Execution Plan and DBCC Commands
• Expert in database activities like Database backup and disaster recovery procedures, Replication Snapshot, Merge and Transactional.
• Strong hands-on experience using Teradata utilities (SQL, B-TEQ, Fast Load, Multi Load, Fast Export, Tpump, Visual Explain, Query man), Teradata parallel support and Unix Shell scripting.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc using SSIS/DTS utility.
• Skilled in error and event handling: precedence constraints, Break Points, Check point and Logging
• Experience in using SSIS tools like Import and Export Wizard, Package Installation and SSIS package Designer.
• Experience in enhancing and deploying the SSIS packages from development server to production server.
• Experience of Data Warehouse principles using Fact Tables, Dimension Tables, Star/Snowflake Schema modeling and data modeling
• Good Knowledge in design partitions and aggregations for performance tuning in SSAS.
• Experience in developing reports using Excel and SSRS, Tableau, Power BI.
• Experience in cloud computing platform like SQL Azure, involved in data migration from
• Experience SQL on- Premises environment to cloud computing platform.
• Worked with Business Analysts, Web development team, and users on Microsoft Business Intelligence solutions.
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-
• Flow, Process Models and E-R Diagrams.
• Good working knowledge on Tableau Desktop and Tableau Server
• Good working knowledge in .Net Framework 2.0/3.0/3.5, VB.Net, C#, ASP.Net, ADO.Net, XML and Web Services.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing. Experience with waterfall and Agile development methodologies and worked with customers in prioritization and planning sprints.
• Provided 24X7 support through on call rotation for PROD and NON-PROD Environments.
EDUCATION:
Bachelor of Technology, JNTU, Hyderabad, India,
Executive Master of Computer Science, University of Cumberland’s, Kentucky.
Master of business administration, university of Cumberland’s, Kentucky.
Technical Skills
Databases
MS-SQL Server 2005/2008/2008R2/2012/2014/2016/2019 MS Access 2003/2007, IBMDB2, Oracle Database 10g/11g, Teradata 15.0
Languages
C, C++, T-SQL, VB Script, Java Script, HTML, XML
ETL Tools
SQL Server integration services (SSIS), Data Transformation Services, SQL Loader
SQL Server Tools
SQL Server Management Studio, SQL Navigator, Microsoft Visual Studio2008/2010/2012, SQL Server Enterprise Manager, BIDS, Sybase Data Tools, SQL Profiler, SQL Networking, Activity Monitor, DTA, Performance Point, PLSQL Developer, Oracle SQL Developer, DB2, Toad, Excel Macro 2007/2010, Erwin, MS Visio, Active Directory, Spotlight for SQL Server, red-gate SQL monitor, SQL Diagnostic Manager, SCOM Monitoring.
OLAP Tools
SQL Server Analysis Server 2012/2008, 2005
Software Packages
MS Office 97/2000/XP, 2003, 2007, MS Outlook 2003, 2007
Operating Systems
Windows 2016/2012/2008/2003/2000/Professional/ NT 4.0 Advanced Server, Unix, Linux.
PROFESSIONAL EXPERIENCE:
NYC Department of Education – New York, NY Dec 2022- Till Date
SQL/ETL developer
Responsibilities:
• Performing tuning the SQL queries and ETL processes for Special Education Office based on business needs and priorities.
• Designing, developing and deploying SSIS packages.
• Designing and developing ETL processes to populate data from different sources.
• Leading the technical oversight for the data mart development by developing and designing Delta Load and Full Load ETL processes.
• Providing solutions that extract, transform and load business data into a data warehouse environment for the Special Education Office, in accordance with standard development practices.
• Designing ETL error handlers and ensuring data structuring as well as data warehousing.
• Integrating the established Software Development methodology into the daily practice of the team to ensure applications deliver the benefits and capabilities as defined by Special Education Office.
• Providing solutions on complex data analysis, creating data models and supporting complex data mapping efforts between disparate systems.
• Creating and implementing database design through ETL that improves data integrity within the data warehouse and/or data mart environments.
• Handling data through linked servers.
• Perform quality assurance and testing of SQL Server environment.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Created and maintained data flow diagrams for existing and future ETL processes.
• Responsible for data migration activities as well as data loading activities using SQL server.
Environment: SQL Server 2005/2008/2008R2/2012/2014/2016, T-SQL, SSIS, SSAS, SSRS, Azure, Query Analyzer, Performance Monitor, PowerShell, Active Directory, AWS, Tableau reporting, Power BI, ServiceNow, Windows 2012/2008R2/2008/2003
Prudential – Newark, NJ Mar 2020 – Oct 2022
SQL Server Developer
Responsibilities:
• Developed highly optimized dynamic SQL, Stored procedures, functions, and database views to implement the business logic and created clustered and non-clustered indexes.
• Design and enhance Star Schema/Dimensional data models for Data warehouse/OLAP environments.
• Reviewed the SQL for missing joins & join constraints, data format issues, miss-matched aliases, casting errors.
• Experience in creating, managing SQL Server AZURE Databases, and setting up Connection Strings and connecting SQL Server AZURE Databases from locally installed SQL Server Management Studio (SSMS)
• I used PowerShell to create and manage Active Directory objects such as users, groups, and OUs. I am also experienced in using PowerShell to manage Exchange Server. I have used PowerShell to create and manage mailboxes, distribution groups, and public folders.
• I am also experienced in using PowerShell to manage SharePoint. I have used PowerShell to create and manage site collections, web applications, and site content. I am also experienced in using PowerShell to manage SQL Server. I have used PowerShell to create and manage databases, tables, and views.
• Implemented batch job processing, scheduling, and production support.
• Scheduled and maintain SSIS packages by daily and monthly using Control M jobs in Production.
• Maintaining both DEVELOPMENT and PRODUCTION Server to make sure they are in sync if not implementing Data refresh on regular bases to achieve this goal.
• Running Index tuning wizard and rebuilding indexes on large tables for faster query response for front end users.
• Working with windows team and app team to streamline the data processes and implement policies to ensure security on all SQL Servers.
• Translated business requirements into BI application designs and solutions.
• Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Responsible for implementation of data viewers, Logging, error configurations for error handling the packages.
• Involved in complete life cycle in creating SSIS packages, building, deploying, and executing the packages in both the environments (Development and Production).
• Created and maintained data flow diagrams for existing and future ETL processes.
• Responsible for data migration activities as well as data loading activities using SQL server.
• Developed UNIX shell scripts to run batch jobs in production.
• Performed quality assurance and Unit/Integration testing of SQL server environment.
• Used TFS for source control and managing development via tasks/bugs.
• Responsible for deploying code changes, code review and code releases in all environments with respect to release deadlines.
• Design, configure, and document Tableau Data Source and Extract
• Mentored business power users to create reports/dashboards using tableau desktop.
• On Call 24X7 support, request queue, daily maintenance, and application support.
• Coordinated with the management to discuss business needs and designed database solutions accordingly.
• Involved in complete software development life cycle (SDLC) including requirements gathering, analysis, design, development, testing, implementation, and deployment.
• Coordinate with Configuration management team in code deployments.
• Presented excellent work attitude and communication skills with multiple teams/departments.
Environment: SDLC, AGILE Methodology, JIRA, SQL Server 2005/2008/2008R2/2012/2014/2016, T-SQL, Teradata SQL Assistant 15.0, BTEQ, ETL, Control M, SSIS, SSAS, SSRS, Tableau, Azure, AWS, SQL Profiler, Performance Monitor, ServiceNow, TFS, Data warehouse, UNIX, XML, INTEGRATION, Windows
Nike – Portland, OR Dec 2018 – Feb 2020
SQL Developer
Responsibilities:
• Writing Stored procedures, User Defined Data Types, Triggers, Constraints, Indexes, CTEs and Batch Scripts using T-SQL
• Build and maintain SQL scripts, indexes and complex queries for data analysis and extraction.
• Maintained and managed database/stored procedure using SQL server tools like performance Tuner and SQL profiler.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring in execution.
• Provide database coding to support business applications using Sybase T-SQL.
• Creating/ Running jobs with packages and Importing data from various sources like Excel, SQL Server, Front base
• Involved in developing and modifying XML reports for exporting the reports to web application.
• Perform quality assurance and testing of SQL Server environment.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Application Testing, Debugging SIT, UAT, Test Clusters, Test Load Balancers.
• UML use case diagrams, Conceptual Flow Diagrams, ER Diagrams by reverse engineering the databases using Visio 2003
• Work with business stakeholders, application developers and production teams and cross functional units to identify business needs and discuss solution options.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Excel and SQL.
• Creating reports using SQL Reporting Services SSRS for customized and ad-hoc Queries
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions and validation based on design specifications for unit testing, system testing and expected results.
• Creating various Jobs, scheduling & running jobs and troubleshooting the failed jobs.
• Worked on the file import framework process for the various flat files structures to get data imported into our database.
Environment: SQL Server 2012/2014/2016, Visual Studio 2008/2010, T-SQL, SSIS, SSAS, SSRS, MS-Excel, XML
Wells Fargo – Charlotte, NC Feb 2017 – Nov 2018
SQL/BI Developer
Responsibilities:
• Created complex stored procedures, Functions, Trigger, Tables, Indexes, Views, SQL joins and T-SQL Queries to test and implement business rules. Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.
• Created stored procedures for commonly used complex queries involving join and union of multiple tables.
• Creating reports using SQL Reporting Services SSRS for customized and ad-hoc Queries
• Created dashboard reports in Power BI Desktop, using SQL Server as Data source. Developed different DAX measures in Power BI to satisfy business needs.
• Involved in conducting training to users on interacting, filtering, sorting and customize views on an existing visualization generated through Tableau desktop.
• Used power shell scripts to write database admin tasks such as index maintenances, to find out file sizes in the disc, alert the users with transaction log files and tempdb growth.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Designed and developed SSIS packages to extract, transform and load data from various data sources into SQL server.
• Created logging, custom logging and error handling packages.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS.
• Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access, and CSV files to data warehouse.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Experience in Designing Data Mart and Data Warehouse using Star Schema and Snowflake Schema and OLAP Technology Analysis Services and Cognos using SQL Server 2008.
Environment: SQL Server 2005/2008/2008R2/2012/2014/2016, T-SQL, SSIS, SSAS, SSRS, Azure, Query Analyzer, Performance Monitor, PowerShell, Active Directory, AWS, Tableau reporting, Power BI, ServiceNow, Windows 2012/2008R2/2008/2003
Verizon – Atlanta, GA Aug 2016 – Jan 2017
SQL Developer
Responsibilities:
• Performed migration from 2005/2008-R2 SQL server databases version to SQL Server 2012 and SQL Server database consolidation.
• Worked on the file import framework process for the various flat files structures to get data imported into our database.
• Created the Stored Procedures, tables, Views depending upon the project requirement.
• Created the deployment scripts after the development is done for every project.
• Automated the SSIS Packages using the SQL Server Agent Jobs.
• Troubleshooter the SSIS/SQL job Agent whenever necessary.
• Created SSIS packages to clean and load data to data warehouse.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Imported the various files provided by the clients into the relational database systems.
• Used the BCP to load large volumes of data from files into tables.
• Worked with Business Analysts and Users to understand the requirement.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement.
• Generated Reports using Global Variables, report expressions and Functions. Designed complex reports like dynamically driven parameterized reports, reports with sub reports, drill through reports using SQL Server reporting services 2008.
• Defined Schemas, i.e., relationships between Measure groups and Dimensions in SSAS.
• Used Visual Source Safe as Version Control Tool.
Environment: SQL Server 2008, SQL Server Business Intelligence Development Studio 2008, SSIS, SSRS, T-SQL, Performance Point Server, Visual Source Safe, SQL prompt, .NET Framework, HP Quality Center, Crystal Reports, TFS, MS-Excel, XML, Windows
WIPRO Limited – India Jul 2012 – Nov 2014
SQL Developer
Responsibilities:
• Developed and optimized complex SQL queries, stored procedures, functions, views, and triggers to support enterprise-level applications and reporting tools.
• Maintained and enhanced data models, schemas, and relational database structures across Oracle and SQL Server environments
• Collaborated with business analysts and application teams to understand reporting needs and translate them into efficient database solutions.
• Worked on data migration and transformation processes using SQL scripts and ETL tools during legacy system upgrades.
• Performed performance tuning of SQL queries and stored procedures to reduce execution time and optimize resource usage.
• Created scheduled jobs and automated tasks for data backups, archiving, and routine database maintenance.
• Participated in code reviews, testing, and deployment processes to ensure database changes adhered to best practices and business standards.
• Ensured data integrity and consistency through rigorous validation, constraints, and transactional control.
• Contributed to database security by implementing role-based access controls and monitoring user activity.
• Documented all development and maintenance procedures for internal audit and team knowledge sharing.
Environment: SQL Server 2008/2012, Oracle 10g/11g, PL/SQL, T-SQL, SSIS, SSRS, SQL Developer, TOAD, Microsoft Excel, Windows Server 2008, Unix/Linux, Erwin Data Modeler, Control-M, Microsoft Visual Studio, Agile & Waterfall methodologies
Contact this candidate